exclude one value from a range in the select expert

I want to list values for a range of customers excluding one: The formula I have is:
{Command.fullname} in "customer1" to "customer 3" and "customer 5" to "customer 7".
The error message keeps telling me a boolean is required? How do i exclude values in the middle of a range?

seb
sebastizAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
bdreed35Connect With a Mentor Commented:
Another way is like this:

{Command.fullname} in "customer1 to customer 7" and
{Command.fullname} <> "customer 4"

Since you are using a Command, I would recommed doing this in the command rather in the record selection formula for performance reasons.
0
 
peter57rCommented:
Hi sebastiz,

 {Command.fullname} in "customer1" to "customer 3" OR  {Command.fullname} in "customer 5" to  "customer 7".


Pete
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.