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
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive