Adding extra budget condition in Beast Mode

PJG
Member
Hi team! This is my first post here, and I'm very new to this. I've built some incredible dashboards in Domo, but when it comes to code, I struggle a lot.
I have this simple Beast Mode working well (although it won't paste those funky apostrophes):
case
when Actual Costs
> Planned Costs
* 1.01 then 'Over Budget'
when Actual Costs
< Planned Costs
* 1.01 then 'Under Budget'
End
need to change the conditions a little to follow these rules:
- <1% & > 20k = Over Budget
- >1% & > 5k = Over Budget
- else, Under Budget
How would I write this as code?
Thank you so much!
0
Best Answer
Answers
-
Wow, that reply was incredibly fast!!! And it works; thank you so much; I didn't realize it would be that simple!
1
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