If to Set

[priyarane]

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

)

[Kushal_Chawda]

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