else part in set analysis

[#1]

Dear all ,

i want to convert this one to set analysis

Please Post the Relative answer

SUM

(if(PRODUCTCODE='APG' or PRODUCTCODE='CAS' or


PRODUCTCODE='EAL' OR
PRODUCTCODE='EAR' OR
PRODUCTCODE='EBI' OR
PRODUCTCODE='EBP' OR
PRODUCTCODE='ECR' OR
PRODUCTCODE='EEI' OR
PRODUCTCODE='EMB' OR
PRODUCTCODE='EMC' OR
PRODUCTCODE='EPM' OR
PRODUCTCODE='FAL' OR
PRODUCTCODE='FBI' OR
PRODUCTCODE='FCSH' OR
PRODUCTCODE='FISE' OR
PRODUCTCODE='FMD' OR
PRODUCTCODE='FPP' OR
PRODUCTCODE='FTFT' OR
PRODUCTCODE='IAR' OR
PRODUCTCODE='LPA' OR
PRODUCTCODE='LPD' OR
PRODUCTCODE='LWC' OR
PRODUCTCODE='MCG' OR
PRODUCTCODE='PPL' OR
PRODUCTCODE='SCN' OR
PRODUCTCODE='SFG' ,RICOMM,RIWP_OD

*0.1))

[CELAMBARASAN]

Try this

Sum({<PRODUCTCODE={'APG','CAS','EAL',''EAR'}>} RICOMM,RIWP_OD*0.1)

Add as much as you want in the Productcode.

But better keep this in a variable instead of hardcoding

like

Sum({<PRODUCTCODE={$(vProductCodes)}>} RICOMM,RIWP_OD*0.1)