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]




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