Beast mode to filter out certain ID field then sum the remaining IDs 'value'

markb

Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart.

Case When sum('value') - (when ID='Liability' Then sum('value')) End

or

Case When 'ID'= does not contain 'Liability' Then sum('value') End

MarkSnodgrass

Try this:

SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)

MarkSnodgrass

Try this:

SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)