Ratio Formula
Hi! I need help to use the beast mode function. I have the following columns:
Name, Ref #, Paid Amount, Savings Amount and Bill Amount.
I want to get the Ratio of Each Name using this formula:
Paid Amount + Savings Amount / Bill Amount
Thank you!
Best Answers
-
You would create a beast mode with the following code:
(SUM(`Paid Amount`) + SUM(`Savings Amount`)) / SUM(`Bill Amount`)
Then you'd create a table card with the first column being the Name and the second column being the beast mode you create.
Here is a video on how to create a beast mode:
If I solved your problem, please select "yes" above
1 -
Use add beast mode to create a new calculation using a formula like
( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly.
Also make sure you have no null or zero values in Bill Amount. Otherwise you will get division errors.CASE
WHEN `Bill Amount` = 0 THEN NULL
ELSE ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
You would create a beast mode with the following code:
(SUM(`Paid Amount`) + SUM(`Savings Amount`)) / SUM(`Bill Amount`)
Then you'd create a table card with the first column being the Name and the second column being the beast mode you create.
Here is a video on how to create a beast mode:
If I solved your problem, please select "yes" above
1 -
Use add beast mode to create a new calculation using a formula like
( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly.
Also make sure you have no null or zero values in Bill Amount. Otherwise you will get division errors.CASE
WHEN `Bill Amount` = 0 THEN NULL
ELSE ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive