2 Replies Latest reply: May 15, 2014 9:57 AM by Hin _ RSS

    Filter

    Hin _

      I have a model that combines data extracted from a aging report and an Excel spreadsheet.  I have a calculated field that returns a value based on the comparison of Gross Amount and Open Amount plus Cash Discount available.  I have a filter to filter in invoices with Gross Amount = Open Amount plus Discount.  I have another filter that filter in invoices with Gross Amount > Open Amount plus Discount.  But some invoices are included in the results of both filters which are exclusive.  Has anyone experienced similar problem, and how you handle that?

        • Filter
          Mike Urbonas

          As a first attempt, I would try using the ROUND function on your to make sure there are no values beyond the second decimal place, which are eluding the filters.  For example, your calc field may display 125.86 but value is "really" 125.86125.

           

          Does that help?

          • Filter
            Hin _

            I tried the rounding, but the result was the same as before.