How can I display zero if a variable is null?
I have a WebI report in which I have a few numeric variables for which I would like to display zeroes if the value is null. I realize can do something like this...
Is that the only way?
I am using BO 4.0 SP4 Patch 3.
Can we try right-clicking that numeric column,choose Format Number.
In the format number window,click on custom and enter 0 for 'undefined' box.