Division by Zero ETL Formula

Hi everyone,
Can someone help me with this issue... trying to input a formula in Magic ETL and I got 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 okay.
Case when `ServiceName` like '%Manual_Only%' then (`InCallMin`) / ((`ReadyMin`+`InCallMin`+`NotReadyMin`+`WrapUpMin`) (`LunchMin`+`BreakTimeMin`+`TrainingMin`+`MeetingMin`)) end
Thanks for any assistance
Best Answer
-
Hi @Shumilex
Looks like an operator is missing between `WrapUpMin`) and (`LunchMin`
What should that operator be? You'll need to utilize your CASE Statement to check for your denominator value being 0 prior to running the calculation with your denominator.
CASE WHEN `ServiceName` like '%Manual_Only%' THEN CASE WHEN ((`ReadyMin`+`InCallMin`+`NotReadyMin`+`WrapUpMin`)(`LunchMin`+`BreakTimeMin`+`TrainingMin`+`MeetingMin`)) = 0 THEN 0 -- Or whatever value you want when the denominator is 0 ELSE (`InCallMin`) / ((`ReadyMin`+`InCallMin`+`NotReadyMin`+`WrapUpMin`)(`LunchMin`+`BreakTimeMin`+`TrainingMin`+`MeetingMin`)) END END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Thank you. I did the below as well, both seem to give the same results:
case
when `ServiceName` like '%Manual_Only%' then (`InCallMin`)/ NULLIF(((`ReadyMin`+`InCallMin`+`NotReadyMin`+`WrapUpMin`) -(`LunchMin`+`BreakTimeMin`+`TrainingMin`+`MeetingMin`)),0)
End
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有