Filtering by two variables

AMalkin

Hello, I'm stuck and can't quite figure out where I'm going wrong. 

I have a data set that includes current and previous claims statuses and approval dates.

I need to isolate those claims which either: 

- have a date change (Approval date check is not 0)

OR

- have a claim status change (Change column blank)

Here is an example: 

I'm currently using a filter with the following formula to isolate the line items I don't care about: 

(contains([Change],"no"))
OR
(Contains([Approval date check], '0'))

But it's not working as expected. Please help!  

Maskell_Rascal

Hi @AMalkin 

You need to put an "!" before your second Contains function. 

Contains([Change],"no") ||
!Contains([Approval date check], '0')

This will give you the desired output. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil