prevent #Num! in report field (1 Viewer)

[Mike Hughes]

I have a report based on a query. In the report there are severl columns and I'm trying to figure the % of current paid to current owed. This % is figured on the report itself and not the query. The problem is that there are some records that have $0 current paid and $0 current owed. When the report is opened these fields have #Num! . Is there someway to make this go away and how do I do it in the report? Attached are a couple of screen shots to help explain what I'm doing. Thanks Mike

 

[Mike Hughes]

I just found one of my old posts which someone help me with so I have it now.

=IIF([PAID CURRENT]=0 or [OWED CURRENT]=0,0,[PAID CURRENT]/[OWED CURRENT])

 

[Sketchin]

Isn't it a division by zero problem?