Expression Calculation

priyarane · ‎2015-02-26

Hi Experts,

Right now I am using expression;

if

(HNAH_3460S = 'Y' ,sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH

,0))/1000000)

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.

Gysbert_Wassenaar · ‎2015-02-26

Try something like this:

if(HNAH_3460S = 'Y' AND HBIO_1201S = 'Y' AND ...etc... AND HUSI_3401S = 'Y', sum(GBM_SCALED_RWA_HNAH)/1000000)

talk is cheap, supply exceeds demand

priyarane · ‎2015-02-26

Not working Gysbert

maxgro · ‎2015-02-26

add other flag fields

sum(if( HBIO_1201S & HBON_10600='YY', GBM_SCALED_RWA_HNAH/1000000))

anbu1984 · ‎2015-02-26

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

buzzy996 · ‎2015-02-26

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