Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Division by 0 Error

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
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question