How to use more than 1 expression in filter

[CherylH]

Hi,

I can do a filter with one expression but have not been successful writing for 2 expressions.

Need to exclude 2 conditions, what is correct expression to write?

[Period] != "x" or [Period]!="DNU"

Thank you in advance,

Cheryl

[MilindG · Accepted solution]

@CherylH  Both should work

[Matt_Davis · Accepted solution]

@CherylH you have to say AND in order to exclude both

[Period]!="x"

AND

[Period]!="DNU"

If you use OR then everything will pass because "x"!="DNU" is true and vice versa "DNU"!="x" is true so all values would pass as true.

[CherylH]

Thanks for the explaination, that makes sense.  I got it to work, been stumped on how to write filter for over a year and never took the time to ask.

Great Help!