Set analysis for IF

[#1]

Hi,

Is there any alternate way for below IF condition? looking for set analysis.

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,

[jagan]

Hi Raj,

Script will work as expected, check the script and result again, if possible attach some same data.

Regards,

jagan.

[#3]

Sure

[#4]

Hi,

Please find the qvd file.

Thank you.