Why won't my filter logic work for this report

Question

Filter Logic:

(1 AND 2 AND 3) AND (4 AND 5 AND 6)

Data shows when 1, 2 and 3 are on the report... but as soon as we add in 4 - there is no data.

1. Duration greater than "0"
2. Worksteps Name equals "provision services"
3. Status equals "open"
4. Worksteps Name equals "ACCEPT FACILITY"
5. Duration greater than "0"
6. Status equals "complete"

So essentially I need results when both 1,2,3 AND 4,5,6 are true.

Why is that? How can I fix it?

Answer 1

You don't even need to add custom logic when all of your operators are AND. That is the default logic.

Criteria 2 and 4 directly contradict each other. The Worksteps Name cannot possibly equal two distinct values at the same time. It seems likely what you really mean is:

1 AND (2 AND 3) OR (4 OR 6)

Note that 5 is redundant and not needed.