This discussion is archived
5 Replies Latest reply: Oct 10, 2012 3:13 AM by 967405 RSS

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

907207 Newbie
Currently Being Moderated
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 11.1.1.5 version.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points