Need help with formulas accommodating dividing by 0

1

Found I have an issue with 0s in my data causing problems. I’m trying to get these formulas to handle dividing by 0 and having issues. I know I need to nest a statement to handle this but getting errors or wrong results.
Can anyone help? I really appreciate it!

Pallet formula
divide(SHIPPED_QUANTITY,UNITS_PER_PALLET)

I tried this but it will show 645 pallets for an order of 645, not what I want.
divide(ORDER_QUANTITY, condition(equals(UNITS_PER_PALLET, 0), 1, UNITS_PER_PALLET))

Pallet pick formula
condition(greaterThanOrEqual(ORDER_QUANTITY,UNITS_PER_PALLET),floor(divide(ORDER_QUANTITY,UNITS_PER_PALLET)),0)

Case test formula
modulus(ORDER_QUANTITY,UNITS_PER_PALLET)

then Case pick
divide(CASE_TEST,UNITS_PER_CASE)

Weight
divide(multiply(divide(UOM_NET_WEIGHT,UNITS_PER_CASE),ORDER_QUANTITY),16)

2

Hello!

Anytime you are using the divide() syntax, you must ensure the number you are dividing by is not zero.

As an example:

Pallet formula
divide(SHIPPED_QUANTITY,UNITS_PER_PALLET)

AFTER:
condition(greaterThan(UNITS_PER_PALLET,0),divide(SHIPPED_QUANTITY,UNITS_PER_PALLET),0)

3

Thank you!