Error in Case statement in Beastmode
user077928
Member
in Magic ETL
Hi there, I'm getting this error when creating a case statement in Beast mode. Hoping someone can help?
Invalid Formula : A column in this calculation did not exist.
This is the case statement. It's pretty simple, and the column definitely exists in the dataset, so I'm not sure why it won't work.
CASE
when `Active days` >= 90 then "90+ Days"
when `Active days` >= 60 then "60-90 Days"
when `Active days` >= 30 then "30-60 Days"
when `Active days` < 30 then "<30 Days"
end
0
Best Answer
-
The issue is that you are using double quotation marks in your then statement. It should be single quotes like this:
CASE when `Active days` >= 90 then '90+ Days' when `Active days` >= 60 then '60-90 Days' when `Active days` >= 30 then '30-60 Days' when `Active days` < 30 then '<30 Days' end
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
The issue is that you are using double quotation marks in your then statement. It should be single quotes like this:
CASE when `Active days` >= 90 then '90+ Days' when `Active days` >= 60 then '60-90 Days' when `Active days` >= 30 then '30-60 Days' when `Active days` < 30 then '<30 Days' end
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
facepalm. thank you.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive