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.
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.
Try:
NOT(IN([column], {"fruits", "vegetables", "dairy"}))
See also:
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |