Not(RequestingArea == "Audit" || "P&C Finance" || "Tax")
Hi @Garrett,
Thank you for the response. Hope your day is going well.
I typed in your suggestion and Nintex didn't like it. The "Choice" Control still shows.
When I type your recommended formula with one item, in this case "Audit", it works fine.
Thoughts?
Try this
Not(RequestingArea == "Audit" || RequestingArea == "P&C Finance" || RequestingArea == "Tax")
Sorry for the initial mistake... I'm in the middle of coding a workflow
Another option is to use Runtime functions, which I've have better luck with in the past. It's also a matter of preference. The below formula should work too.
not(or(contains(RequestingArea,"Audit"),or(contains(RequestingArea,"P&C Finance"),contains(RequestingArea,"Tax"))))
Hi That worked too. I had to add an "or" and one parenthesis, but your suggestion worked. Should I pose this as another question, so that you get credit for solving this too?
Thanks!
Solution:
not(or(contains(RequestingArea,"Audit"),or(contains(RequestingArea,"P&C Finance"),or(contains(RequestingArea,"Tax")))))
@bamaeric
Nintex edited my response, so it looks a little wonky .. but the solution is correct.
Good catch. That's why you troubleshoot. No need to add another question - a kudo is fine. Glad you were able to get a solution.