KNOWLEDGE BASE

Changing Zeroes to Null Values


Published: 30 Oct 2013
Last Modified Date: 03 May 2016

Question

How to change zeroes to null values.

Environment

Tableau Desktop

Answer

  1. Navigate to Analysis > Calculated Field....
  2. Name the field and enter a formula similar to the following:
    IF [<Measure Name>] != 0 THEN [<Measure Name>]
    ELSE NULL 
    END
  3. Click OK.
Did this article resolve the issue?