Sum Condition

[CBoardy]

Hi All 

I want to create a sum with conditions that select values depending on the value from another field in the table. The two Fields are 'Values'(Number)  & 'P&L Category' (String).

Sum({$<[Values] [P&L Category] = {'OIE'}>})

I want to sum all of 'Values' where 'P&L Category' = 'OIE'

is this possible to complete?

TIA

[henrikalmen · Accepted solution]

If you want to sum(Values) but with predefined P&L Category you do it this way using set expression: sum({<[P&L Category]={'OIE'}> Values)

[CBoardy]

Thats great thanks,  how would I add another condition?

sum({<[P&L Category]={'OIE'}, [Var] = {'TGT'}>} Values)

Is that correct? 

@henrikalmen 

[henrikalmen]

Yes, that's right!