Or clause doesn't work

[davidogundipe]

Every time I want to use the OR clause to filter for multiple conditions, the filter fails and everything is categorized as true. 

This is an example of my OR clause written in the custom filter window. Please let me know if you can help! 

[Resource.CurrentRank] = "Staff" OR "Senior" OR "Manager" 

[davidogundipe · Accepted solution]

[Resource.CurrentRank] = "Staff" OR [Resource.CurrentRank] = "Senior" OR [Resource.CurrentRank] ="Manager"

Figured it out! I had to do this ^

[PhilipMannering]

Each clause of an expression needs to evaluate as True or False. 

The expression you want is,

[Resource.CurrentRank] = "Staff" OR
[Resource.CurrentRank] = "Senior" OR
[Resource.CurrentRank] = "Manager" 

You can also write,

[Resource.CurrentRank] IN ("Staff", "Senior", "Manager" )

[Emil_Kos]

Hi,

You need to use IN command.

Try this syntax [Resource.CurrentRank] IN ("Staff", "Senior",Manager")

I am writing on my phone so there might be an issue with syntax but please check. Hope this works.