Custom Filter Issue

[Wrichard]

I am trying to filter out the data pertaining to "US" and "MX" using the custom filter tool. This is the formula i'm using:

[territory] = "US" AND [territory] = "MX"

The workflow runs, but it shows zero results for T for this and when I check the F, there are entries for MX and US. 

I also tried this formula as well with the same results. 

Contains([territory], "US") AND CONTAINS([territory],"MX")

Suggestions? 

[drew9 · Accepted solution]

Hi @Wrichard ,

You need to use OR instead of AND. what your filter is looking for right now is for a territory that equals both MX and US, which will never be true. Using OR, if territory equals either MX or US, it will be flagged as true.

Hope this helps.

[DawnDuong · Accepted solution]

hi @Wrichard 

On first look, I think the reason is because the formula is using "AND".

E.g. Something cannot be "RED" and "GREEN" at the same time, right? for that same reason, any record cannot be equal to BOTH "US" AND "MX" at the same time.

If the objective is to filter in records where "Territory" is either "US" or "MX", we should use the operand "OR".

Try this: 

[territory] = "US" OR [territory] = "MX"

Contains([territory], "US") OR CONTAINS([territory],"MX")

Contains([territory], "US",1) OR CONTAINS([territory],"MX",1) __> if you want to ignore the case.

Dawn.

[Wrichard]

That worked, knew it was something simple. Thank you all!