Re: Slice with multiple conditions

Tom_automated · 10-23-2020 01:56 PM

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.

Aaron_Blau

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

Tom_automated

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

Try:

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