Division by Zero ETL error

Emma

Hello

Can someone help me with this error... I am inputting a formula in Magic ETL and am receiving a division by zero error. How can I rectify it? I know in some cases the divisor in my calculation will be 0 but that is fine. An example of the 2 formulas I've tried below. Thanks for any insight.

IFNULL(`Total Stock`=0,0,`Total Stock`/`Conservative Max Qty per plt`)

CASE WHEN`Total Stock`=0

THEN null

ELSE (`Total Stock`/`Conservative Max Qty per plt`)

END

GrantSmith

Hi @Emma

You need to check for your denominator to be zero, not your numerator. Try this (will return 0 if `Conservative Max Qty per plt` is 0)

CASE WHEN `Conservative Max Qty per plt` = 0 THEN 0 ELSE `Total Stock`/`Conservative Max Qty per plt` END

GrantSmith

Hi @Emma

You need to check for your denominator to be zero, not your numerator. Try this (will return 0 if `Conservative Max Qty per plt` is 0)

CASE WHEN `Conservative Max Qty per plt` = 0 THEN 0 ELSE `Total Stock`/`Conservative Max Qty per plt` END

Emma

oh Goodness, thank you for the advice @GrantSmith