Calculation in report

[tannagirl]

I have added new criteria to a report to include a new product line. One of the calculated fields on the report is giving a #Num! instead of a 0. What do I need to add to the calculation to show 0 instead of #Num!

Existing Calculation:

=Sum([Indemnity_Paid])/[Grand_Indemnity_Paid]*100

 

[79ssecca]

try this...

=Sum([Indemnity_Paid])/nz([Grand_Indemnity_Paid],0)*100

although I'm not sure. As I read your formula you are multiplying Grand_Idemnity by 100 and then deviding the result by Indemnity_paid if that is correct this might be a better solution.

=Sum([Indemnity_Paid])/nz([Grand_Indemnity_Paid]*100,1)

good luck