This content has been marked as final. Show 2 replies
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?