KNOWLEDGE BASE

Error "The calculation contains errors: Reference to undefined field" in Calculated Field


Published: 21 Feb 2015
Last Modified Date: 19 Feb 2018

Issue

When editing a calculated field, the following error might occur:

The calculation contains errors: Reference to undefined field [field name]

Environment

Tableau Desktop

Resolution

Verify that the field referenced in the error message exists and the reference matches the field name exactly.

Cause

There is no existing field with that exact name. 

A few reasons a field may not exist or no longer exist:
  • The spelling of the field in the calculation differs from the spelling of the field in the data pane.
  • The name of the field was changed in the data source.
  • The data was recently pivoted and the field no longer exists because it became part of pivot field names.
  • The data source was recently replaced and the field not longer exists in the new data source or has a different name.
Did this article resolve the issue?