KNOWLEDGE BASE

Worksheet Does Not Show Certain Values After Using a Calculated Field


Published: 31 Jul 2014
Last Modified Date: 13 May 2016

Issue

When aggregating multiple values by using a calculated field, the values in the Text field appear blank.

Environment

Tableau Desktop 

Resolution

Wrap each [Value] in a ZN() function. For example: ZN(SUM([Sales]))+ZN(SUM([Profit])).

Cause

Tableau Desktop will return the result of the entire calculation as null instead of expected aggregation if any of the value in a formula is null. This is because null values are not considered to be numbers and Tableau Desktop cannot perform aggregations on null values. 
Did this article resolve the issue?