If Logic help

[dhanu_today]

Hi Everyone,

I have the fileds CUST_ID,PRODUCT,CUSTOMER_TYPE,P_CODE  and PD_CODE.

How can I get the list of CUST_ID’s based on the below parameters.

1) IF(WildMatch(P_CODE,'883','887','903','945','946','939') or WILDMATCH(PD_CODE,'ASSOC1', 'CLUB01', 'DEFENC', 'EDUC01', 'SOCIE1', 'SYTEDU', 'TRUS01', 'TRUS02', 'WELFAR1', 'SECT25', 'GRM000')
        or WILDMATCH(CUSTOMER_TYPE,'ASSOCIATION/ TRUSTS')

AND WILDMATCH(PRODUCT,'CA','SA') ,CUST_ID) AS CASA_BASE,  (TO GET THE COUNT UNDER PRODUCT  CASA CATEGORY)
2) IF( WILDMATCH(CUSTOMER_TYPE,'ASSOCIATION/ TRUSTS') AND WILDMATCH(PRODUCT,'FD'),CUST_ID) AS FD_BASE (TO GET THE COUNT UNDER PRODUCT  FD CATEGORY)

3)In the third condition we have avoid the CUST_ID’s which contains CUSTOMER_TYPE as 'ASSOCIATION/ TRUSTS' under the  PRODUCT ‘FD’

How we can can merge the logic(1 and 2) to fill the third conditin.

Let me know if in case of any clarifications.

Thanks in adv,

Dhanu

[bbi_mba_76]

Hi,

maybe you can add some flag fields to the script and use those flags in the expressions.

[dhanu_today]

Thanks BBI..But Need help in the way to do that !!

[dhanu_today]

Hi any hint from experts.Its a little bit urgent.  Thanks, Dhanu