How to use SUM(column) when column may conatin a null value
Greetings,
I have a simple report which produces calculated values for vendors. Two of the calculated columns are conditional ... calculate if the condition is true else display null.
My question is how do I calculate a total for the column (BO_RANDS) when its value may be null?
Currently, I am using <?format-number:sum (BO_RANDS);'999G999G999G999D99'?>. If one of the detail lines contains a null value for BO_RANDS, the total is null.
Suggestions?
Many thanks for any comments, suggestions or hints you may send my way.
Tom
I have a simple report which produces calculated values for vendors. Two of the calculated columns are conditional ... calculate if the condition is true else display null.
My question is how do I calculate a total for the column (BO_RANDS) when its value may be null?
Currently, I am using <?format-number:sum (BO_RANDS);'999G999G999G999D99'?>. If one of the detail lines contains a null value for BO_RANDS, the total is null.
Suggestions?
Many thanks for any comments, suggestions or hints you may send my way.
Tom
0