Forum Discussion

DavidBerndt's avatar
DavidBerndt
Qrew Cadet
6 years ago

How can I create a deeper set of filters?

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?

2 Replies

  • 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?
  • Are you sure the report filters don�t work for you. They indent 3 levels deep.


    Or like you say. Use a formula field.