#Num! error in report

[randolphoralph]

I have created a report and used the following formula and the report is returning a #Num! error. I have read it is returning the error since it is tring to divide by 0. How would I change the formula to get it to return a 0 instead of a #Num! error?

=([SumOfTotal Points]/[SumOfTotal Possible Points])

 

[SOS]

You can try this:

=IIF([SumOfTotal Possible Points] <> 0,[SumOfTotal Points]/Nz([SumOfTotal Possible Points],1))

So this tells it if the divisor doesn't equal zero then use the function but also the NZ function checks to see if the field is not null and if null uses a 1 to divide by.

 

[randolphoralph]

Thank you! That did remove the error, but when the result of the formula is 0 it is returning a blank value.

How would I get the formula to display a 0 instead of a blank?

 

[SOS]

Perhaps this:

=IIF([SumOfTotal Possible Points] <> 0,[SumOfTotal Points]/Nz([SumOfTotal Possible Points],1)[B][COLOR=red],0)[/COLOR][/B]
[B][COLOR=#ff0000][/COLOR][/B] 
[B][COLOR=#ff0000]

[/COLOR][/B]

 

[randolphoralph]

SOS

I was able to find a solution by trying the following.

=IIF([SumOfTotal Possible Points] = 0,0,[SumOfTotal Points]/Nz([SumOfTotal Possible Points],1))

It appears to be working properly. Thank you for your help.