using IF then WHEN
Ben_Gilbert
Member
in Charting
Hi
I want to add another variable to the above equation but can't get it to work. In my Excel days, I would use an IF statement. Here is my equation:
when 'primary class' = 'supermarkets and grocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`)
Thanks
Ben
1
Best Answer
-
you can use AND to combine logcal expressions together if both should be true or OR if one needs to be true. Alternatively you can add an additional WHEN clause to your case statement to do something diffferent:
CASE WHEN `primary class` = 'supermarkets and grocery stores' THEN SUM(CASE WHEN `Split answer` = 'Female' THEN `` ELSE 0 END) / SUM(`Value`) WHEN `primary class` = 'some other store' THEN SUM(`some other logic`) END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
you can use AND to combine logcal expressions together if both should be true or OR if one needs to be true. Alternatively you can add an additional WHEN clause to your case statement to do something diffferent:
CASE WHEN `primary class` = 'supermarkets and grocery stores' THEN SUM(CASE WHEN `Split answer` = 'Female' THEN `` ELSE 0 END) / SUM(`Value`) WHEN `primary class` = 'some other store' THEN SUM(`some other logic`) END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 767 Beast Mode
- 70 App Studio
- 43 Variables
- 715 Automate
- 185 Apps
- 460 APIs & Domo Developer
- 56 Workflows
- 14 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive