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
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

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 
This works.Thanks.
Prajwal
0
Categories
 10.5K All Categories
 7 Connect
 917 Connectors
 250 Workbench
 466 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 477 Datasets
 193 Visualize
 252 Beast Mode
 2.1K Charting
 11 Variables
 17 Automate
 354 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 246 Distribute
 62 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 173 Product Ideas
 1.2K Ideas Exchange
 12 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive