Replace Undefined/Blank with a value in Beast Mode
Hi,
I am calculating accuracy with a formula inside Beast Mode:
(A  F) / A * 100.
There are few instances where the denominator is 0.
For those instances, I am getting blank values as shown below:
I want to replace the blank/undefined with a different value
I tried to use the CASE and IFNULL BeastMode functions but that did not work.
Can someone help me with this?
Thanks,
Prajwal
0
Best Answer

Here's what I've done in the past that has worked. Call out the denominator as zero calulcation first, then go on to the calculation if it's fine.
CASE
WHEN IFNULL(SUM(`AdjustedSalesRevenue),0) = 0 THEN 0
ELSE
[calculation]
END
Does something like that work for you?
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers

This works.Thanks.
Prajwal
0
Categories
 11.3K All Categories
 6 Private Company Board
 2 APAC User Group
 12 Welcome
 45 Domo News
 10.2K Using Domo
 2K Dataflows
 2.6K Card Building
 2.3K Ideas Exchange
 1.3K Connectors
 354 Workbench
 271 Domo Best Practices
 14 Domo Certification
 483 Domo Developer
 58 Domo Everywhere
 113 Apps
 734 New to Domo
 86 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 305 仲間に相談
 667 ひらめき共有