Division by zero

[Mike Hughes]

In my report for each worker I’m trying to figure what the % of current paid to current owed. Some workers have no current paid ($0) or no current owed ($0) or $0 in both fields. When I run the report I get an error “Division by zero”. Could someone please show me how to fix this? See attached screenshots. Thanks Mike

 

[Alansidman]

Try this:
=IIF([currentPaid]=0 or [currentOwed]=0,0,[currentPaid]/[currentOwed])

 

[Mike Hughes]

That worked. Thank you very much. Mike