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
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive