Division - Beast Mode - Exceptions

imelendez

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

 

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

 

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

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