Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Right now I am using expression;
if
(HNAH_3460S = 'Y' ,sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
As above mentioned one flag I am using(HNAH_3460S='Y') but my requirement is, my expression should work with all Flags if its 'Y' else 0.
Please suggest me if its in other way also like SETanalysis.
My flags are
HBIO_1201S
HBON_10600
HBUS_3607S
HMUS_3285S
HNAH_3460S
HSI_32900
HTCD_37130
HUSI_3401S
Thank you.
Try something like this:
if(HNAH_3460S = 'Y' AND HBIO_1201S = 'Y' AND ...etc... AND HUSI_3401S = 'Y', sum(GBM_SCALED_RWA_HNAH)/1000000)
Not working Gysbert
add other flag fields
sum(if( HBIO_1201S & HBON_10600='YY', GBM_SCALED_RWA_HNAH/1000000))
Can you explain what is not working?
If you want to calculate Sum even if one of the flags are Y, then change AND to OR in Gysbert's solution
u can also try,
If(HBIO_1201S='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HBON_10600
='Y',S
sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HBUS_3607S
='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HMUS_3285S
='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HNAH_3460S
='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HSI_32900
='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HTCD_37130
='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000)
If(HUSI_3401S
='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH
,0))/1000000),0 ))))))))close all brackets here