Filter Troubles

[Brad1]

I want to capture this:

([State] = "ID" OR [State] = "WA" OR [State] = "CA" AND [Plan_A] = "X")       OR      ([State] = "ID" OR [State] = "WA" OR [State] = "CA" AND [CHAIN] = 100 Or [CHAIN] = 200 Or [CHAIN] = 300 Or [CHAIN] = 400)

The above is just my latest attempt.  All States are contained in my results.  Anyone know what I'm doing wrong?  Thanks in advance.

[Brad1]

I split this out into to Filter Tools and it works.  State in one, rest in the other.  Can it all be place in one Filter Tool?

[NicoleJohnson · Accepted solution]

Try this one formula in your filter tool:

[State] IN ("ID","WA","CA") AND ([Plan A]="X" OR [CHAIN] IN (100,200,300,400))

Does that work for you? :)

NJ

[patrick_digan · Accepted solution]

@Brad1 You'll want to use parens to further group things to make it more clear what your after. You can also use the IN function. I'm thinking you'll want something like

[State] IN("ID","WA","CA") AND ([Plan_A] = "X" OR [CHAIN] IN(100,200,300,400))

[Brad1]

Thx.  Put it on my tab.  lol