Multiple Case statements

Hi there,
I am trying to make a table that has the following columns.
Customer Name / AW 2022 Pre-Orders / AW 2022 Replen Orders / AW 2023 Pre-Orders
So what i need is a beast mode formula that can get me data based off the 'Invoiced Month' of 10, 11, 12. The 'Invoiced Year' of 2022 and 2023. And finally the 'Sales Order Type' of PRE-ORDER or REPLEN ORDERS
I got something like the below for the "AW 2022 PRE-ORDERS" column but I'm not very knowledgeable on beast mode formulas and its not working, please let me know what I'm doing wrong!
CASE when `Invoiced Month` in ('10', '11', '12')
then
when 'Invoiced Year' = '2022'
then
when `Sales Order Type` in ('PRE ORDER', 'PRE ORDER POST DEADLINE') then `Row Net` else 0 end
Comments
-
@JackB116 you are on the right track. When you want to look at multiple conditions, you want to use 'and'. So you would just replace 'then when' with 'and'
CASE when `Invoiced Month` in ('10', '11', '12')
and 'Invoiced Year' = '2022'
and `Sales Order Type` in ('PRE ORDER', 'PRE ORDER POST DEADLINE') then `Row Net` else 0 end
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1 -
Ah thank you so much Rob, surprised I managed to get so close!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive