OR in slices

[fr_nick]

In DATA > Slices

I want to have a slice that refrences a col that has a dropdown 

The dropdown has 6 options.

I want the slice to show content from two of the six options

I've tried different OR formulas but nothing is working, thank you. 

For example  this works: 

Row filter condition  [STATUS] = "Delivered"

I want this to work :

Row filter condition  [STATUS] = "Delivered", "Ready to Deliver"

Thank you 

[JuneCorpuz]

Try this formula

OR( IN( "Delivered", [Status] ), IN( "Ready to Deliver", [Status] ) )

[fr_nick]

Thanks June, I tried that and it gave me this: 

Table slice 'STATUS is ON DECK OR ROLLING' uses an invalid filter condition '=OR( IN( "On Deck", [STATUS] ), IN( "Rolling", [STATUS] ) )'. Parameter 2 of function IN is of the wrong type

[JuneCorpuz]

I'm sorry I assumed your column is an EnumList. Can you please share the configuration of the table?

[fr_nick]

The col is a dropdown via data validation, just a list of values

[JuneCorpuz · Accepted solution]

Have you tried OR([STATUS] = "Delivered", [STATUS] = "Ready to Deliver")?

[fr_nick]

That worked !!! Thank you!