5 Replies Latest reply: Oct 10, 2012 5:13 AM by 967405 RSS

    How to replace 0(zero) in place of null values

      Hi All

      I have one requirement, how to replace 0 in place of null values? I already using data format as UPTO 2 for this column and also caluclated Items are not working(it is showing empty cells) if any column contains null values. So please help on this.

      I tried 2 ways using ifnull and case statement, but it is not working

      Am using version.