Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I would like to know how to find the outstanding days .
I have attached the sample excel file.
could anyone help me.
thanks in advance.
Hi,
Please check the attached file for solution.
Regards,
Jagan.
Hi
thanks for the reply.
I need to show the outstanding amount ant the days.
Your application shows the normal days.
its not checking whether its having outstanding amount.
to check we have to consider the ID field for amount.
to calculate the days we have to consider the ID and starting Voucher no and Voucher date.
Hi,
Please check the attached file. Hope this helps you.
Regards,
Jagan.
Hi
thanks for ur reply.
we have to consider the first invoice date.
For ex, Category A and ID 2 for Jan
the outsatnding amount is 500-250=250
the outstanding days is 31/01/2012-12/20/2011=42
dont consider the partial payments..
they paid 250 on 01/20/2012 but the actual amt is 500 raised on 12/20/2011
we have to consider the 12/20/2011.
thanks in advance
Hi,
Please check the updated attachment for solution.
Regards,
Jagan.
Hi
thanks for ur response...
when i remove the ID field from the chart.
the values getting mismatched. also i need to show in pivot table.
I wont Show the ID fields
Hi,
If you remove ID then the chart works based on Category and ID is not considered. So, all calculations are done based on the Category.
Regards,
Jagan.