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
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 284 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 570 Datasets
 2K Magic ETL
 3.4K Visualize
 2.4K Charting
 604 Beast Mode
 16 App Studio
 29 Variables
 602 Automate
 152 Apps
 419 APIs & Domo Developer
 29 Workflows
 2 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 365 Distribute
 99 Domo Everywhere
 264 Scheduled Reports
 2 Software Integrations
 98 Manage
 95 Governance & Security
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive