Can there be multiple "THEN" statements?
Here is my formula that is currently working!
(CASE
WHEN SKULabs Cost
>= 25 AND SKULabs Cost
<= 50 AND line_items_product_id
THEN '25-50 Bucket' ELSE 'not 25-50'
END
)
I'd like to add at 'Qty On Hand' > 1 in this formula but I'm unsure of where / or if there can be 2 "THEN" statements.
I'd like to be able to subtotal my Beast Modes, but they don't seem to subtotal when "subtotal is applied. So, I'd also like to add a subtotal in the Beast Mode as well, but again, I'm unsure of where to place it.
Thank you in advance your time and assistance!
Best Answer
-
@Laura_M1 Yes, you can add as many conditions as you want as long as each one is preceded by "WHEN" like this:
- case
- when A then B
- when XYZ then 123
- when blue then red
- …
- else 'Other'
- end
You can find more about Case statements in the Logical functions section of this Knowledge Base article:
1
Answers
-
@Laura_M1 Yes, you can add as many conditions as you want as long as each one is preceded by "WHEN" like this:
- case
- when A then B
- when XYZ then 123
- when blue then red
- …
- else 'Other'
- end
You can find more about Case statements in the Logical functions section of this Knowledge Base article:
1 -
Also can you show an example of how you are trying to subtotal your beast modes, along with the formula you're using?
0 -
Thank you!
Currently I'm just using the Chart PropertiesWe don't currently have any Beast Modes with Subtotals - is a way to subtotal them without a formula?
Ideally we'd love to have 1 column that shows Inventory OH and then all of our pricing buckets laid out. Of our options we can choose from, Beast Modes & Measures, I cannot see inventory next to the pricing buckets Either the Pricing Buckets show data or the inventory shows data; not both at the same time.0 -
Thank you MichelleH!
Apologies on the delay in response. We are getting ready for a tradeshow and I'll be leaving shortly. I will circle back to this next week! Have a great weekend!0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 805 Beast Mode
- 79 App Studio
- 44 Variables
- 761 Automate
- 189 Apps
- 480 APIs & Domo Developer
- 75 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive