Slice with multiple conditions

I’m trying to create a slice that does not equal to 3 entries. Basically I need an everything else slice. So If my column is labeled ‘food’, I want everything but ‘fruits’, ‘vegetables’, or ‘dairy’. I can’t seem to figure out the syntax. [column] <> “fruits”,“vegetables”,“dairy” doesn’t seem to work.

0 3 811
3 REPLIES 3

Aaron_Blau
Participant III

OR([Food]<>"Fruits",[Food]<>"Vegetables",[Food]<>"Dairy")

Is there a way to add in catch all after the entry? Something like Fruits*, Dairy*? I’m still getting Fruits included and I’m thinking it’s because of blank spaces "Fruits " does not get filtered.

Steve
Participant V

Try:

NOT(IN([column], {"fruits", "vegetables", "dairy"}))

See also:





Top Labels in this Space