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
0
Best Answer

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
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers

oh Goodness, thank you for the advice @GrantSmith
0
Categories
 10.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 297 仲間に相談
 649 ひらめき共有