Dynamic Replace and Expression

[jenettd]

Hi,

I'm using the Dynamic Replace tool to find values in a field and attach a rule to them. I'm using an excel spreadsheet that has a list of the rules. The expression I'm using isn't working. I want it to find values not equal to Yes or No and attach the Fail rule (under the RuleEval column) to them. The expression is only finding values that don't equal Yes and not looking at the "No" part of the expression and attaching the Fail rule to them.

This is what is in my Rules spreadsheet - 

New Field	Rule	Expression	RuleEval
RuleEval	9	[Rule]=9 AND [Value] != "Yes" OR "No"	Fail - Does not contain Yes or No

This is the output. It is failing the No values when it shouldn't.

Value	RuleEval
No	Fail - Does not contain Yes or No
No	Fail - Does not contain Yes or No
No	Fail - Does not contain Yes or No

[patrick_digan · Accepted solution]

@jenettd  Close! Try changing your expression to something like this:

[Rule]=9 AND [Value] Not in ( "Yes","No")

[jenettd]

That worked! Thank you!