Sum if using Case When

Cintia · October 2022

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

MarkSnodgrass · October 2022

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?

MarkSnodgrass · October 2022

Try this:

SUM(CASE WHEN `Data` in ('Goal','Pipeline','in P&L') THEN `Total` ELSE 0 END)

This should get the total you want.

Cintia · October 2022

I don't want to sum all of them, I want to sum them separately

MarkSnodgrass · October 2022

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?

Cintia · October 2022

Yes I need to create 3 beast modes separate, but it only worked with the first column

MarkSnodgrass · October 2022

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.

Sum if using Case When

Best Answer

Answers

Categories