Syntax error in beast mode case statement
Hi,
I'm new to domo and struggling a bit on what seem fairly simple issues so apologies if this is a stupid question.
I am using a Case statement in Beast mode to try and return the number 1 if certain criteria are met. I've managed to return the number 1 as text so far but need to return it as a number rather than text. When I remove the quote marks from around the 1s it gives me a syntax error.
CASE
When `Stage` = 'Cancelled' THEN 1
When `Stage` = 'Rejected' THEN 1
When `Stage` = 'Not Interested' THEN 1
When `Stage` = 'Invited to Apply' THEN 1
Else ''
end
Thanks!
Best Answer
-
Hi,
I think your problem is the ELSE clause, you are returning different data types. You should Return Null Or 0.
Null Example :
CASE
When `Stage` = 'Cancelled' THEN 1
When `Stage` = 'Rejected' THEN 1
When `Stage` = 'Not Interested' THEN 1
When `Stage` = 'Invited to Apply' THEN 1
ElseIFNULL(1,1)
endZero Example:
CASE
When `Stage` = 'Cancelled' THEN 1
When `Stage` = 'Rejected' THEN 1
When `Stage` = 'Not Interested' THEN 1
When `Stage` = 'Invited to Apply' THEN 1
Else 0
endHope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.2
Answers
-
Hi,
I think your problem is the ELSE clause, you are returning different data types. You should Return Null Or 0.
Null Example :
CASE
When `Stage` = 'Cancelled' THEN 1
When `Stage` = 'Rejected' THEN 1
When `Stage` = 'Not Interested' THEN 1
When `Stage` = 'Invited to Apply' THEN 1
ElseIFNULL(1,1)
endZero Example:
CASE
When `Stage` = 'Cancelled' THEN 1
When `Stage` = 'Rejected' THEN 1
When `Stage` = 'Not Interested' THEN 1
When `Stage` = 'Invited to Apply' THEN 1
Else 0
endHope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.2 -
Thanks Ricardo, that worked perfectly.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 593 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 96 Manage
- 93 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive