Expression to QV

[priyarane]

Hi Community,

what would be the expression for below one

sum(CASE WHEN A.METHOD_ORIGINAL != 'STD' AND(

(DECODE(A.METHOD_NEW,'STD','SEG',A.GUARANTEE_METHOD)='LGD' AND A.TRANCHE_GUARANTEE_TYPE='GUARANTEED') OR (A.TRANCHE_COLLATERAL_TYPE='COLLATERALIZED' AND A.COLLATERAL_BIS_PRODUCT='IMP_LGD_EFF') OR A.TRANCHE_COLATERAL_TYPE ='COLLATERALIZED' AND A.COLLATERAL_BIS_PRODUCT IN ('RRE_COL', 'LEASING_CRE_COL','CRE_COL','OTHER_PH_COL','LEASING_EQUIPMENT_COL','LEASING_RRE_COL','RECEIVABLE_COL')) THEN ROUND(A.COLLATERAL_ASSIGNED_AMMOUNT/(B.EXCH_RATE*1000),5)

[Anonymous]

Try to break it into small ones and then try

[priyarane]

I am trying but no luch, can some one please help me here

[roger_stone]

Maybe it's me, but that DECODE statement doesn't seem to make sense.