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!  

[Emil_Kos]

Hi @AMalkin,

I have created a workflow for you but I am not sure if I get what is your problem.

If this filter doesn't work for you can you give us a little bit more details why your solution isn't working as expected? 

Maybe you should use OR function instead of AND? 

[Maskell_Rascal · Accepted solution]

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