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
 7.6K All Categories
 Connect
 917 Connectors
 242 Workbench
 472 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 445 Datasets
 30 Visualize
 196 Beast Mode
 2K Charting
 7 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 14 Manage
 35 Governance & Security
 19 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 15 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部