Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can replace value like below but its not working ..
individually all logic corect but i write with in its not working..
i write this logic in expression
..IF(WildMatch(PROD_PRODUCT_GROUP_NEW_USER,'SMS ') ,
IF(IF(WildMatch(SUMMARY_PARTICULARS,'SEMIS TOTAL'),SUMMARY_PARTICULARS),
IF(FLAG_PROD = 'Y',
SUM({<FORECAST_MONTH_PROD_NEW = {'$(vSelectedMonth)'}>}FORECAST_VALUE_PROD_NEW),
SUM({<FORECAST_MONTH_PROD = {'$(vSelectedMonth)'}>}IF( WILDMATCH(SUMMARY_PARTICULARS,'*TOTAL*'),FORECAST_VALUE_PROD) ) ))
,IF(FLAG_PROD = 'Y',
SUM({<FORECAST_MONTH_PROD_NEW = {'$(vSelectedMonth)'}>}FORECAST_VALUE_PROD_NEW),
SUM({<FORECAST_MONTH_PROD = {'$(vSelectedMonth)'}>}IF(NOT WILDMATCH(SUMMARY_PARTICULARS,'*TOTAL*'),FORECAST_VALUE_PROD) ) ))
Hi Prakash,
Try changing the first line like this:
IF(WildMatch(PROD_PRODUCT_GROUP_NEW_USER,'SMS*')
Else please share some sample data to validate the expression.
Thank you for your response but that name is exactly sms,
ok i changed to sms* i got the same.
Can you share a sample application with sample data ?