If to Set

priyarane — Thu, 31 Mar 2016 14:16:37 GMT

hi Community,

Can we convert below expression from if to set analysis.

if( (Only({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}INCORPORATION_NAME)<>

Only({<%Month = {'$(=$(=vPrevMonth))'},%Year = {'$(=$(=vPrevYear))'},CURRENCY = {'$(=$(vCurr))'}>}INCORPORATION_NAME)) or

(Only({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}RISK_NAME)<>

Only({<%Month = {'$(=$(=vPrevMonth))'},%Year = {'$(=$(=vPrevYear))'},CURRENCY = {'$(=$(vCurr))'}>}RISK_NAME)) or

(Only({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}IR_Band)<>

Only({<%Month = {'$(=$(=vPrevMonth))'},%Year = {'$(=$(=vPrevYear))'},CURRENCY = {'$(=$(vCurr))'}>}IR_Band)),

INV_ID

)

Re: If to Set

Kushal_Chawda — Fri, 01 Apr 2016 07:17:16 GMT

I think it will be Hard to covert it into set analysis , but i think you can try to create the Flag in script.