Need amount remaining for recent due date...

Fri, 31 May 2013 10:24:29 GMT

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')

Re: Need amount remaining for recent due date...

Fri, 31 May 2013 23:01:47 GMT

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