Along with above conditions, we need to consider those customers who are having CASA accounts as per logic but having Customer Type not equal to 'Newone’ under FD Product.
Dimension level I wrote the below logics individually how we can consolidate both logics as one to fill the above req. We no need to consider the Cust_id’s which are having product as FD and Customer_type not equal to ‘Newone’ in the second script.(it’s the difference between both the logics)
=if(wildmatch(PRODUCT_CODE,'883','887','903','945','946','939') and wildmatch(PROMO_CODE,'AbcOC1', 'CbaB01', 'DcdENC', 'EzcC01', 'SoaIE1',
'SYTEDU', 'TwuS01', 'TRUS02', 'WaeFAR1', 'SECT25', 'Gae000') and
((wildmatch(CUSTOMER_TYPE,'Newone’) and WILDMATCH (PRODUCT,'CA',’SA’)) or (not wildmatch(CUSTOMER_TYPE,'Newone’) and WILDMATCH (PRODUCT,'FD')) ) ,CUST_ID)
Note, if these are all fields from the same table, you could consider creating a flag field in the script to mark these customers and use the flag field to select them. Or you could create bookmarks for both sets and use the bookmarks in set analysis expressions.
B)To calculate the FD customers we have consider the conditions below.
Customer Type – ‘Newone’.
C)To calculate the CASA_FD customers we have consider the conditions below.
Let say if I have 100 FD customers(from B) with the CUSTOMER_TYEPE as ‘Newone’ and from the 100 custid’s We have check whether they are having CASA product or not with CUSTOMER_TYEPE is not equal to ‘Newone’.If yes we have to show that information also.
It means in domain level one custid having multiple products.We have to capture the customers details by various parameters.
