10 Replies Latest reply: Mar 5, 2015 10:39 AM by Jennie Elliott RSS

    Exclude certain data by row

    Jennie Elliott

      This is a sample of a chart I am working on. In the Vendor Inv column as well as the Notes column, AP puts in the trigger CLEAR in either one or both of these fields. The end use of the report is to export into Excel with the final output being uploaded in the software that generates the actual printing of the checks.

       

      I need to exclude any rows that have the trigger CLEAR in it.

       

      How would I either script it or write an expression to handle this.

       

      Thanks in advance!

       

      Exclude CLEAR.png