Skip to content
Advertisement

CASE to sum column based on boolean

I have:

Then I group by to get the counts but how do I sum X when Y is TRUE only? Or get the % of A in relation to true/untrue?

Advertisement

Answer

how do I sum X when Y is TRUE only?

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement