Match and Wild Match of fields and values

[richard24best]

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

[rubenmarin]

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...)

[richard24best · Accepted solution]

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)