I think the problem is: (access ne 2 or access ne 1) I think that will always be true. The or access ne 1 will find access that has value 2. So if you have row that has access being 2 then (access ne 2 =falseoraccess ne 1 = true) -> true
Change it to this:
daysuntilmovein eq 3
and city eq 5
and access ne 2
and access ne 1
and (stage eq 1 or stage eq 4)
and type ne 1
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.