How can I create a deeper set of filters?

Question

I'm trying to create a report that is used for auditing and would prefer to have a single view rather than multiple different reports as some records may fail for multiple reasons. The problem I'm finding is I cannot create a set of filters deep enough. Basically I have to do the following:

Audited is not checked
AND (
(Audit criteria 1 AND audit criteria data 1)
OR
(Audit Criteria 2 AND (criteria data 1 OR criteria data 2))
)

I cannot get that last set to indent as you can see below (Arrival and departure are to be OR'd against the after hours being unchecked.

Any suggestions?

DavidBerndt · Answer

Well I found what should have been obvious is to break the Or into 2 different sets.  But if that didn't work are there options or would I have to create some formula field instead?

Sign up

Login to the community