Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am trying to use the below expression but not able to get the exact count.
Could you please check and advice what i am missing or doing wrong?
if(match(Status_Business,'Unable To Remediate (Requires Human Intervention)')>0 and "Closure Reason"='' or
Not wildmatch(("Closure Reason") , '*Received Tech/Business Signed Off*','*Received Tech/Business Sign Off*',
'*Received tech/business signoff*','*Received Tech/ Business signoff*','*Received Tech/ Business Sign off*'),0,1)
I am getting count with other texts as well so need your expertise.
Regards,
Richard
When i used len("Closure Reason") =0 it worked
if(match(Status,'Unable To Remediate (Requires Human Intervention)')>0
and (len("Closure Reason")=0 or
Not wildmatch("Closure Reason" , '*Received Tech/Business Signed Off*','*Received Tech/Business Sign Off*','*Received tech/business signoff*',
'*Received Tech/ Business signoff*','*Received Tech/ Business Sign off*')>0),1,0)
Hi, "Closure Reason"='' goes with the and or with the or? if it goes with the or section yuo'll need parenthesys:
and ("Closure Reason"='' or not wildmatch...)
When i used len("Closure Reason") =0 it worked
if(match(Status,'Unable To Remediate (Requires Human Intervention)')>0
and (len("Closure Reason")=0 or
Not wildmatch("Closure Reason" , '*Received Tech/Business Signed Off*','*Received Tech/Business Sign Off*','*Received tech/business signoff*',
'*Received Tech/ Business signoff*','*Received Tech/ Business Sign off*')>0),1,0)