Filter, String contains Word

[wonka1234]

Hi,

I am trying to apply the follwing filter:

[ColA] != 0 and [Category] = "Other"

But I am trying to alter the Category filter to : Contains the word Other. Not filter strictly for Other.

[PhilipMannering · Accepted solution]

You want the following,

[ColA] != 0 and contains([Category], "Other")

[wonka1234]

Thanks, do you know how to make it NOT contains?

[Luke_C]

Hi @wonka1234 :

[ColA] != 0 and !contains([Category], "Other")