Show only Remaining Amount

[sandee]

Hello Everyone,

I have a data with “Invocie Number”, its Total Amount and Overdue amount above then 0 days

In the “Overdue Amt” column I have invoices and credit notes, if I will match credit and invoices then I will be left with only amount 1,950 See below Highlited.

I only want to highlight the remaining outstanding, please could you spare some time and advise.

[daxer-almighty]

@sandee 

Not able to understand. You have to be much clearer and detailed in your explanation. Some fully worked out example showing exactly what's going on would be helpful as well as a sketch of the model.