KNOWLEDGE BASE

Calculated Fields Return NULL or Unexpected Results After Extract Refresh


Published: 03 Nov 2017
Last Modified Date: 07 Nov 2017

Issue

After you refresh an extract, a calculated field returns different results. Common examples include the field becoming invalid, returning NULL results, or differently formatted results.

Environment

Tableau Desktop 10.3 and older versions.

Resolution

Option 1

Upgrade to Tableau Desktop 10.4. For more information, see Upgrade Tableau Desktop.
 

Option 2

Add a dummy parameter to the calculation. For example:

IF [Parameter 1] = 1
THEN <original calculation>
END

Cause

In Tableau Desktop 10.3 and earlier, when refreshing an extract Tableau Desktop queries the data source to compute the calculation. Some calculations are not supported or return different values on a live connection. See the related links for some specific occurrences.

When a parameter is added to the calculation, Tableau Desktop will not try to materialize the calculation into the extract because the values may change if the parameter value changes.

Additional Information

  • After the extract is completed, if the formula is modified enough then the calculation will work. For example, if white space is added to the middle of the formula.
  • The unexpected results will remain if the connection is switched to live. On a live connection, no modifications to the calculation will return the expected results.
Did this article resolve the issue?