Using 'not equals' and 'AND' is giving a result like 'OR'

Hello,

My data set includes rows from 2018 March to 2019 March. I'm using a filter like this:

[Year] != "2019" AND [Month] != "3"

I expected this to only exclude rows with Year=2019 and Month=3. Instead, it excludes all rows where Month=3 (for both 2019 and 2018) and all rows where Year=2019 (for January, February, and March).

Is there an alternative to my filter expression?

Also, I'd like to understand why AND/&& is behaving like an OR.

Thank you,

Hope

Expression

Accepted answers

Try this:

[Year] = "2019" AND [Month] = "3"

Choose false side.

Cheers,

All comments

Try this:

[Year] = "2019" AND [Month] = "3"

Choose false side.

Cheers,

Ah, this worked! Thank you so much!

!([Field1] = 2019 AND [Field2] = 3)

This would work too.

When you are negating you have to be very careful how you do it. Set theory can be tricky.

Cheers,

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703