I've been scrounging through lots of examples, but don't seem to find one that combines a bunch of and this,this this where one of the 'this' has multiple potential answers. I think my written version has a clear enough conversation voice. Any help with syntax is great.
IF
[Coverage In Question]="No"
&& [Liability Category]!="unknown"
&&[Large Loss]="no"
&&[Total Loss Ind]="no"
&&[Paid]=0
&&[MCC]="N"
&&([Task Status]="Estimate Received"OR"Supplement Received")
&&([SIU Status]="Investigation Closed"OR"No Referral"OR"Referal not accepted")
&&([Reserve Age Bucket]="<10 Days"OR"10-30 Days"OR"30-60 Days"),
&&([Coverage]="COLL"OR "COMP"OR "LIPD")
Then "Y"
ELSE "N"
ENDIF
Solved! Go to Solution.
I 'think' I solved my own problem? BUT since I couldn't find other examples, I'll leave this here for someone else and maybe it'll help them?
IF [Coverage In Question]='No'
&&[Liability Category]!="unknown"
&&[Large Loss]="no"
&&[Total Loss Ind]="no"
&&[Paid]=0
&&[MCC]="N"
&&[Task Status]IN("Estimate Received","Supplement Received")
&&[SIU Status]IN("Investigation Closed","No Referral","Referal not accepted")
&&[Reserve Age Bucket]IN("<10 Days","10-30 Days","30-60 Days")
&&[Coverage]IN("COLL","COMP","LIPD")
Then "Y"
ELSE "N"
ENDIF