Discussions

Expand all | Collapse all

How can I create a deeper set of filters?

  • 1.  How can I create a deeper set of filters?

    Posted 08-24-2018 21:19
    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.
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1747965/RackMultipart20180824-83538-1mtamkw-Capture_inline.PNG?1535145508">

    Any suggestions?


  • 2.  RE: How can I create a deeper set of filters?

    Posted 08-24-2018 21:31
    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?


  • 3.  RE: How can I create a deeper set of filters?

    Posted 08-24-2018 22:52
    Are you sure the report filters don�t work for you. They indent 3 levels deep.


    Or like you say. Use a formula field.