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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive