Division by 0 Error

[Former Member]

I have the following formula setup but it still returns a division by 0 error. I have used this same setup in several reports and have never had this issue. Any ideas?

IF {SHIPPER_LINE.SHIPPED_QTY} = 0 THEN 0 ELSE {INVENTORY_TRANS.ACT_MATERIAL_COST}\{SHIPPER_LINE.SHIPPED_QTY}

[Former Member · Accepted solution]

Try:

IF isnull({SHIPPER_LINE.SHIPPED_QTY}) or {SHIPPER_LINE.SHIPPED_QTY} = 0 THEN 0 
ELSE {INVENTORY_TRANS.ACT_MATERIAL_COST} / {SHIPPER_LINE.SHIPPED_QTY}

If it still doesnt work might want to check for nulls for {INVENTORY_TRANS.ACT_MATERIAL_COST} and try again.

[Former Member · Accepted solution]

I got it. My division mark was incorrect. Thanks for the help.