5 Replies Latest reply on Jun 24, 2015 12:47 PM by elizabeth.hoffberg.0

    How to exclude null value in Tableau Calculation

    phuviet.pham

      Hi Everybody,

       

      I have the Sheet like belows. There is no Sale Data in some Months. for Example: There is no Sale Data for Category A in 2003/02 and 01/2004. When i calculated the Difference in Sale from current Month to last month (right click on Sale==>  Quick table Calculation ==> Differrence), Tableau used "null value" in the calculation.

      For example:

      Sale of Category A 10 2003/01 is 10. There is no data for Sale of Category A in 2003/ 02. But Tableau still shows me the Defference between Sale in These 2 months as -10.

      So how can i exclude the null value in Calculation?. Thanks

       

      null value.bmp