Dear All,
I am trying to write an IIf statement to feature the formula below. The formula is in my report
The some of amount = 0, and therefor the result of my formula below is returning a result #Num!
=Sum([Sum total of records])/Sum([SumOfAmount])
anks
=IIf([SumOfAmount]=0,0,[Sum total of records]/[SumOfAmount])
Can someone please tell me what is wrong with the above statement.
Th