Set analysis

[#1]

Hi,

I want change the if condition to Set analysis and for the below expression I want change.

sum(if(SCENARIO='S1' or SCENARIO = 'JUMP-OFF' ,PD_FLOOR_WA*EAD_WA,0))/sum(if(SCENARIO='S1' or SCENARIO = 'JUMP-OFF' ,EAD_WA,0))*100

Thank you.

[alexandros17]

try this

sum({$ <SCENARIO={'S1',''JUMP-OFF'}>} PD_FLOOR_WA*EAD_WA)

/

sum({$ <SCENARIO={'S1',''JUMP-OFF'}>} EAD_WA)*100

[its_anandrjs]

Hi,

Try this

sum( {<SCENARIO={'S1','JUMP-OFF'}>}  PD_FLOOR_WA*EAD_WA )

/

sum( {<SCENARIO={'S1','JUMP-OFF'}>}  EAD_WA )*100

Regards,

Anand

[alkesh_sharma]

Try this:

((sum( {<SCENARIO={'S1'}>}  PD_FLOOR_WA*EAD_WA )+

sum( {<SCENARIO={'JUMP-OFF'}>}  PD_FLOOR_WA*EAD_WA ))

/

(sum( {<SCENARIO={'S1'}>}  EAD_WA )+

sum( {<SCENARIO={'JUMP-OFF'}>}  EAD_WA )))*100

[Colin-Albert]

(Sum({$ <SCENARIO={'S1','JUMO-OFF'}>} PD_FLOOR_WA*EAD_WA)

/

Sum({$ <SCENARIO={'S1','JUMO-OFF'}>} PD_FLOOR_WA) ) *100

[#6]

Let me try

[#7]

Hi, With the above expressions, I could't get my output as expected and my outoupt should be as below.

Could you please suggest?

When  selected:S1 my output should be as below, P0 should be disappear.

Period	Scenario =S1	Scenario =S2	Scenario =S3
P1	2%	-	-
P2	7%	-	-
P3	1%	-	-

When Jump off selected then my output should be like below, basically Jump-off=P0

Period	Scenario =S1	Scenario =S3	Scenario =S2
P0	4%	4%	4%

Thank you,

[rubenmarin · Accepted solution]

Hi Raj, I think you asking for intersection between selected values and set analysis, you can try:

sum( {<SCENARIO*={'S1','JUMP-OFF'}>}  PD_FLOOR_WA*EAD_WA )

/ sum( {<SCENARIO*={'S1','JUMP-OFF'}>}  EAD_WA )*100

[#9]

Working perfect Ruben, Thank you.

[#10]

Hi Ruben,

Is there any way for the below expression:

if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))

Thank you