topic Re: Sum Condition in App Development

Sum Condition

CBoardy — Fri, 24 Feb 2023 14:52:24 GMT

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

Re: Sum Condition

henrikalmen — Fri, 24 Feb 2023 15:09:43 GMT

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)

Re: Sum Condition

CBoardy — Fri, 24 Feb 2023 15:26:49 GMT

Thats great thanks, how would I add another condition?

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

Is that correct?

@henrikalmen

Re: Sum Condition

henrikalmen — Fri, 24 Feb 2023 15:34:52 GMT

Yes, that's right!