How can I create a deeper set of filters?

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
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?
Photo of David Berndt

David Berndt

  • 262 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of David Berndt

David Berndt

  • 262 Points 250 badge 2x thumb
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.
(Edited)