Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if
(CaseAge='>30',
Count(if(Interval(DATE((date(Today(),'DD/MM/YYYY')-date(INCIDENT_DATE,'DD/MM/YYYY')),'DD/MM/YYYY'),'DD')>30
AND NOT STATUS_DESC='Resolved'AND NOT STATUS_DESC='Cancelled' AND
NOT WildMatch(UPPER(CUSTOMER_NAME),'*EAST*','*WEST*','*SOUTH*','NORTH*','KSA*','DUBAI')
AND CLASS_DESC='Incident'and WildMatch(UPPER(CUSTOMER_NAME),'*ERICSSON*','*NOKIA*','*NSN*'),IN_INCIDENT_NO))
Please correct the above if have something wrong in the expression...
Use the wildmatch as shown below, which ever matches your requirement. Wildmatch returns the position of the <Data1> in the <Fieldname>. If this equals to 0, it means <Data1> is not part of the string in <Fieldname>.
Wildmatch(<fieldname>, <Data1>, <Data2>,...) <> 0 or
Wildmatch(<fieldname>, <Data1>, <Data2>,...) =0
try this
if(CaseAge='>30',
Count(if(Interval(date(Today(),'DD/MM/YYYY')-date(INCIDENT_DATE,'DD/MM/YYYY'),'DD')>30
AND STATUS_DESC<>'Resolved' AND STATUS_DESC<>'Cancelled' AND
CUSTOMER_NAME<> WildMatch(UPPER(CUSTOMER_NAME),'*EAST*','*WEST*','*SOUTH*','NORTH*','KSA*','DUBAI')
AND CLASS_DESC='Incident' and WildMatch(UPPER(CUSTOMER_NAME),'*ERICSSON*','*NOKIA*','*NSN*'),IN_INCIDENT_NO))