Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try,
like
Sum(if(Today() > DueDate,Amount))
Regards
It should be like
Sum ( {< Due date = {'<$(=today ())'} >} Amount)
Hi,
try,
like
Sum(if(Today() > DueDate,Amount))
Regards
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)