Expression in Set analysis

[#1]

Hi  Community,

How to write the below expression in Set

If CR RWA <> 'GMR or OPR' then SUM (RWA)

Thank you

[Kushal_Chawda]

try

=sum({<[CR RWA]-={'GMR','OPR'}>}RWA)

[Gysbert_Wassenaar]

You can't. Set analysis does not support branching. But if you mean sum(if([CR RWA] <> 'GMR or OPR', RWA) then you can use sum({<[CR RWA]-={'GMR or OPR'}>}RWA)

[#4]

Hi Gysbert,

Its -  If CR RWA <> 'GMR' or 'OPR' then SUM (RWA)

[#5]

So In such case, we have to use straight IF condition like

if([CR RWA] <> 'GMR' or 'OPR'(sum(rwa))

Am I right Gysbert?

[#6]

Hi Kush,

It's act like AND. I mean to say it will remove both(GMR and OPR) from sum.

[Gysbert_Wassenaar · Accepted solution]

If you're testing for two values 'GMR' and 'OPR' and not one value 'GMR or OPR' then try if([CR RWA] <> 'GMR' or [CR RWA] <> 'OPR',sum(RWA))