3 Replies Latest reply on Jun 29, 2016 3:36 PM by Shinichiro Murakami

    Null Values

    Swarup K

      I want to display zero's in place of NULL's , for example  city Aberdeen 2011,2012,2013 are nulls there is no value i what to show it as 0's.

       

       

      I tried using IFNULL and ISNULL functions but its not working.

      I am using the below formula for 2012 year

       

       

      IF YEAR([Order Date])=2012 AND ISNULL([Order Date]) THEN 0

      ELSE [Sales]

      END

       

       

      Is anything wrong with my formula.I am using super store excel. Need help.

       

       

      Thanks

      Swarup