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.
Add comment