Need amount remaining for recent due date...

[#1]

I need help to get amount remaining for the recent due date.

=

sum(if([AR Aging Net Amount Due Remaining-Invoice]>=0,[AR Aging Net Amount Due Remaining-Invoice],0))

this is the expression for amount remaining and i need to get amt remaining for recent due date. due date expression is

=

date([AR Aging Due Date],'DD-MMM-YY')

[#2]

Have you tried something like this:

=

sum(if([AR Aging Net Amount Due Remaining-Invoice]>=0 AND [AR Aging Due Date] = YourDueDate,[AR Aging Net Amount Due Remaining-Invoice],0))

Matt