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
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 563 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 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
- 94 Manage
- 91 Governance & Security
- 9 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive