Hi, I have data that looks like the following:
Date Number Department
2023-10-31 2 VB01
2023-10-30 2 VB01
2022-01-01 2 VB08
2022-02-02 3 VB03
2023-10-30 4 VB04
Basically I want to filter the data so that any record that has the Number 2 AND has Department VB01 AND has either 2023-10-31 OR 2023-10-30 as the date should be filtered out. So in the example above the first two rows should be filtered out.
I am trying to use the following filter but no matter what I try it doesn't work.
[Number] != 2
AND
[Department] != "VB01"
AND
([Date] != "2023-10-30"
OR
[Date] != "2023-10-31")
Any help is really appreciated!
Solved! Go to Solution.
@Crispy131 , recheck data type of yours Number column. If it is text, you need to quote the value in the filter expression.
!([Number] = '2' and [Department] = 'VB01' and [Date] in ('2023-10-30', '2023-10-31'))
Hope it helps.