IF [Employee SID] = [Row+1:Employee SID] OR [Employee SID] = [Row-1:Employee SID] AND [Error Type] = [Row+1:Error Type] OR [Error Type] = [Row-1:Error Type]
THEN 1
ELSE 0
ENDIF
This is capturing the following 2 entries as a match and returning a "1" when it should be a "0" because the Error Type does not match, only the Employee SID is a match:
Employee SID = 123456
Error Type = Complaint
Employee SID = 123456
Error Type = Privacy
Can someone please assist? Thank you!
