I would suggest you generate a set of extra entry rows and the you can generate a running sum. Prerequisites In the KPI Modeler, you need to specify the periods for which you want to calculate the DSO figures (for example for This means ABC Contractor collected payments an average of 25 days after invoicing during the month of May. =EDATE (start date, number of months) Step 1: Ensure the starting date is properly formatted go to Format Cells (press Ctrl + 1) and make sure the number is set to Date. This may be for measuring and rewarding performance or this may be for external reporting to financing sources. WebNever use any DSO calculation by itself. and resolving variances for General The formula i am using is =SUM (OFFSET (B6,0,MATCH (-1,B6:W6,-1)-1,1,-12)). I need a formula that allows me to enter new monthly data that will automatically calculate and update a total of 12 months. Note: As a sanity check, a companys days sales outstanding (DSO) assumptions should also be referenced against the average DSO of comparable peers. SELECT * from table where customer = current_row customer and yearmonth >= current month - 12 and yearmonth