Outstanding days in Set Analysis

[#1]

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.

[jagan]

Hi,

Please check the attached file for solution.

Regards,

Jagan.

[#3]

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.

[jagan]

Hi,

Please check the attached file.  Hope this helps you.

Regards,

Jagan.

[#5]

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

[jagan]

Hi,

Please check the updated attachment for solution.

Regards,

Jagan.

[#7]

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

[jagan]

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.