Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
How to write the below expression in Set
If CR RWA <> 'GMR or OPR' then SUM (RWA) |
Thank you
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))
try
=sum({<[CR RWA]-={'GMR','OPR'}>}RWA)
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)
Hi Gysbert,
Its - If CR RWA <> 'GMR' or 'OPR' then SUM (RWA)
So In such case, we have to use straight IF condition like
if([CR RWA] <> 'GMR' or 'OPR'(sum(rwa))
Am I right Gysbert?
Hi Kush,
It's act like AND. I mean to say it will remove both(GMR and OPR) from sum.
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))