Overdue

[gautik92]

I want to find Accounts payable Overdue

VendID       Amount       DueDate

1                 100             15-10-2016

2                 200             20-12-2016

3                 300             25-12-2016

4                 100             30-12-2016

i am using this formula

=if(aggr(Today() > DueDate,DueDate),Sum(Amount))

as per this i want to get 300 but getting ( - )any ideas

[vinieme12]

It should be like

Sum ( {< Due date = {'<$(=today ())'} >} Amount)

[PrashantSangle · Accepted solution]

Hi,

try,

like

Sum(if(Today() > DueDate,Amount))

Regards

[tamilarasu]

Hi Gowtham,

If your date format is set like below then you can use Pujari's solution,

SET DateFormat='DD-MM-YYYY';

Sum ( {< [DueDate] = {'<$(=Today ())'} >} Amount)

If not, you can use

Sum({< [DueDate] = {"<$(=Date(Today(),'DD-MM-YYYY'))"} >} Amount)