Show Nulls as "0.00" in BEx Analyzer
Can anyone share advice on how to display nulls as zeros (0.00) in the BEx Analyzer? I don't want to change the data, since this could cause an incorrect value to be reported in the event of averaging. And, I don't want to change the base-level display settings in BEx, because every user may not want nulls displayed as zeros. I want to be able to change this on a case-by-case basis. A business analyst and I have not been able to figure out how to do this within the BEx Analyzer.
Thanks in advance.