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

markb · 2023-11-09T01:13:44+00:00

There was an error rendering this rich post.

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

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

Find more posts tagged with

Filters

Beast Mode

Accepted answers

MarkSnodgrass

Try this:

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

All comments

MarkSnodgrass

Try this:

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of