want to know if i can use mutiple filed values in a set expression through wild match

[#1]

Hi Team,

Please help correcting the below as am unable to take the three accounts(ericsson, nokia, and nsn which are having their own sub accounts) in a set expression.

COUNT

({$<REGION={"=WildMatch(UPPER(CUSTOMER_NAME),'*ERICSSON*')","=WildMatch(UPPER(CUSTOMER_NAME),'*NOKIA*')","=WildMatch(UPPER(CUSTOMER_NAME),'*NSN*')"},INCIDENT_DATE={">=$(=daystart(MAX(INCIDENT_DATE)))"}>} IN_INCIDENT_NO )

Regards,

Hassan

[swuehl]

Nor sure if I understand what you want to do. You want to modify your selection in REGION by a match with CUSTOMER_NAME?

Assuming you want to modify your selection in CUSTOMER_NAME, then maybe try just:

COUNT(

{$<CUSTOMER_NAME = {"*ERICSSON*","*NOKIA*","*MSN*"}, INCIDENT_DATE={">=$(=daystart(MAX(INCIDENT_DATE)))"}>}

IN_INCIDENT_NO )