Calculated Fields Return NULL or Unexpected Results After Extract Refresh

Published: 03 Nov 2017
Last Modified Date: 14 Oct 2019


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.


Tableau Desktop 10.3 and older versions.


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>


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.

Discuss this article... Feedback Forum
Did this article resolve the issue?