Crystal Report 9i -- How to display zero in Weighted Average 1

[aksm47]

Hi,

I have a problem in displaying zero for the Weighted average that has zero for denominator.

Right now, my report display "Empty" values for the weighted average column (Response Rate).

e.g. Mail Response Response Rate
100 50 0.50%
0 0
200 100 0.50%

I want it to display as

e.g. Mail Response Response Rate
100 50 0.50%
0 0 0.00%
200 100 0.50%


Thanks.

Drew

 

[lbass]

Start your formula with a clause that accounts for a zero denominator:

if {table.mail} = 0 then 0 else
<your weighted average formula here>

-LB

 

[aksm47]

The weighted average is from the "Summary" of crystal report. I have no control on it, it just automatically changed the values into empty. Is there any way to set the option for "Summary" function in crystal report that could resolve this?

Thanks.

-AK

 

[GJParker]

File -> Report Options -> make sure Convert other NULL values to default is ticked.

HTH

Gary Parker
MIS Data Analyst
Manchester, England