Division - Beast Mode - Exceptions

imelendez · May 2019

Experts,

So I have a division formula that we built in a beast mode. Some of my data on the bottom part of the divisor comes up as 0. So what I did to account for that is to do a NULLIF. However, when you divide by NULL Domo freaks out when you are trying to present this in a card.

What ways would you recommend to circumventing situations like these? Could you provide an example?

Humbly,

Isaiah Melendez

Godiepi · May 2019

Hi @imelendez

In the Dojo we have seen this type of question and other members have come up with great solutions and great examples. I am attaching these 2 links below for you to take a look if they help you solve your question. if not, let me know to look at your case further

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Division-to-exclude-0-s/m-p/16061#M1393

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Beast-Mode-error-message-dividing-by-zero/m-p/29453#M4100

Godiepi · May 2019

Hi @imelendez

In the Dojo we have seen this type of question and other members have come up with great solutions and great examples. I am attaching these 2 links below for you to take a look if they help you solve your question. if not, let me know to look at your case further

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Division-to-exclude-0-s/m-p/16061#M1393

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Beast-Mode-error-message-dividing-by-zero/m-p/29453#M4100

imelendez · May 2019

Thanks @Godiepi , the second article worked like a charm!

Division - Beast Mode - Exceptions

Best Answer

Answers

Categories