Getting beast mode to calculate 10% value of a column
Hello Domo masters,
Help Needed.
I am trying to build a card that would display projects in a table when the following criteria is met:
1. Approaching budget (Actuals >90% of Budget)
2. Over Budget (Actuals > Budget)
I tried the following calculation in testing:
Case
When `Project Actuals YTD` >= ((`New Budget`+`Rollover Budget`) * .90) then 'Approching Budget'
When `Project Actuals YTD` > (`New Budget`+`Rollover Budget`) then 'Over Budget'
End
The result I am getting is as follows:
Projects that are over budget are shown accurately but the Beast Mode calc column only displays 'Approaching budget' for all projects rather than what is intended by the calculation. The projects at this moment should show 'Over Budget' rather than 'Approaching Budget'.
i am thinking the * .90 could be not a valid calculation?
Any insite would be much appreciated.
Best Answer
-
Take a close look at your calculation , All are showing Approaching because you have the condition of >= for approching and > for Over. it happens to be that passing 90% , 100%, 110% applies to the Approching cal.
I recomment adjusting it by setting another piece that said >= 90% but <= 100%... same thing saying between 90% and 100%, that way evrything surpassing 100% will be tagged as Over Budget
Case
When `Project Actuals YTD` >= ((`New Budget`+`Rollover Budget`) * .90)
and `Project Actuals YTD` <= (`New Budget`+`Rollover Budget`)
then 'Approching Budget'
When `Project Actuals YTD` > (`New Budget`+`Rollover Budget`) then 'Over Budget'
Enddoes it make sense ?
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Answers
-
Take a close look at your calculation , All are showing Approaching because you have the condition of >= for approching and > for Over. it happens to be that passing 90% , 100%, 110% applies to the Approching cal.
I recomment adjusting it by setting another piece that said >= 90% but <= 100%... same thing saying between 90% and 100%, that way evrything surpassing 100% will be tagged as Over Budget
Case
When `Project Actuals YTD` >= ((`New Budget`+`Rollover Budget`) * .90)
and `Project Actuals YTD` <= (`New Budget`+`Rollover Budget`)
then 'Approching Budget'
When `Project Actuals YTD` > (`New Budget`+`Rollover Budget`) then 'Over Budget'
Enddoes it make sense ?
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
That totally makes sense. I was able to correct it and now its working like Magic.
Thank you.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 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
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 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
- 109 Community Announcements
- 4.8K Archive