DSO calulation

[abhaysingh]

Dear All,

please help me out to find out DSO..

my DSO calculation is like below

Say i m in Apr 15 than For Apr DSO calculation is [Net Outstanding/ (jan Amount+Feb AMount + March Amount)/3) *30]

for Mar 15, DSO calculation will be [Net Outstanding/ (DecAmount 14+JanAMount  15+ FebAmount 15)/3) *30]

and for Feb, DSO would be [Net Outstanding/ (Nov Amount 14+Dec AMount 14 + JanAmount 15)/3) *30].

Now i want to show Trend for these three Month.

Kindly help

thanks

[giakoum]

these may help you :

Accumulative Sums

Calculating rolling n-period totals, averages or other aggregations