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 18.104.22.168 version.
Please look into this issue, Problem with new caluclated items.
If any column contains empty cells then that caluclated items showing empty cells.
if any column contains data for all the rows then data is coming properly for caluclated item rows
I am thinking problem with NULL values. So pls help on this how to overcome this problem?