Slice help

[sheebee22]

Hi, I'm trying to do a very basic slice. I want it to show only those schools listed as "active." 

I *think* that this is the correct expression, but it doesn't work:

Can somebody help?! Thank you!

[Suvrutt_Gurjar · Accepted solution]

It sounds your [Status] column could be of enumlist type. If so and if you need only one value at a time as status, please make the column of enum type.

[sheebee22]

Yes! This was it! such a simple fix, THANK YOU!!

[JJ_TechSupport]

Glad you asked bcz I've come across this too and usually hack-away on it until I find a formula that works. 

Now I know to check the field type.  

[JJ_TechSupport]

I think the answer is in the error message.

Try:

([Status]=Active)

without the quotes.

[sheebee22]

Thank you but that didn't work: