Help

Filter: Does NOT have all of...

Topic Labels: Base design
Solved
Jump to Solution
298 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Morris2
6 - Interface Innovator
6 - Interface Innovator

How can I do a negative filter? Let's say I have a multiple select field with letters A-E. I can easily filter to show all records that contain all of D, E, and F. But I want to filter OUT all records that contain all of D, E, and F. Just D is fine, D and E is fine, etc. 

Thanks for your help!

1 Solution

Accepted Solutions

I figured it out. My brain hurts trying to figure out why it works, but it works. I grouped: "has none of D or has none of E or has none of F." Thanks for talking me through it.

See Solution in Thread

4 Replies 4
Dan_Montoya
Community Manager
Community Manager

Depending on the field type use “contains” or “any of”. 

Thanks Dan for the quick reply. I don't think that would work for my situation. I want to say "Don't use any record with ALL of D, E, and F."

Using "any of" would not allow for records with just D or just D and E.

Using "contains" I believe would have the same results unless I'm missing something. 

I meant “does not contain” or “has none of”.  You can use groups to get more complicated filters. 

I figured it out. My brain hurts trying to figure out why it works, but it works. I grouped: "has none of D or has none of E or has none of F." Thanks for talking me through it.