Advanced Filters - using 'not contains' and 'is not' filters

Hello,

I have TWO filters that include 'not contains' and 'is not' and want to make sure neither value appears in my smart list.

Most of the members won't have both but I want to make sure that if they have one, they are excluded.

Should I use (4 and 5) instead of (4 or 5)?

Attached is a screenshot. Filters 4 and 5 are the ones in question.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by SanfordWhiteman

It's everyday Boolean logic. We use it implicitly in real life, too.

Let's say I'm going to the grocery store and someone says "get me some produce that's not a vegetable and not orange".

Section IS Produce AND ((Type IS NOT Vegetable) AND (Color IS NOT Orange))

New Participant

Should I use (4 and 5) instead of (4 or 5)?

Yes.

New Participant

Thanks, Sanford!

What's the reasoning? Is it because I am using negative filters?

Shane Rourke

SanfordWhitemanAccepted solution

New Participant

It's everyday Boolean logic. We use it implicitly in real life, too.

Let's say I'm going to the grocery store and someone says "get me some produce that's not a vegetable and not orange".

Section IS Produce AND ((Type IS NOT Vegetable) AND (Color IS NOT Orange))

Sign up