Sum if using Case When
How can I write this formula in an effective way?
(CASE WHEN `Data`= 'Goal' THEN SUM(`Total`) ELSE 0 END)
(CASE WHEN `Data`= 'Pipeline' THEN SUM (`Total`) ELSE 0 END)
(CASE When `Data`= 'in P&L' THEN SUM (`Total`) ELSE 0 END)
I need to create for every name, but it only works with the first one that I created
Best Answer
-
Do you want to sum them separately and then add them together? Or do you want them as 3 separate calculations? If you want them as 3 separate calculations, then you would create 3 different beast modes, one for each.
It may be easiest if you explain what it is you are trying to achieve. What are you trying to display?
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Try this:
SUM(CASE WHEN `Data` in ('Goal','Pipeline','in P&L') THEN `Total` ELSE 0 END)
This should get the total you want.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
I don't want to sum all of them, I want to sum them separately
0 -
Do you want to sum them separately and then add them together? Or do you want them as 3 separate calculations? If you want them as 3 separate calculations, then you would create 3 different beast modes, one for each.
It may be easiest if you explain what it is you are trying to achieve. What are you trying to display?
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Yes I need to create 3 beast modes separate, but it only worked with the first column
0 -
Try moving the SUM to the outside of your CASE statement instead of being inside. I would also double-check your data to make sure you are matching exactly, such as case-sensitivity and extra spaces.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 203 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive