Unlike a budget or calendar year forecast, a rolling 12-month forecast adds one month to the forecast period each time a month is closed so that you are continuously forecasting for 12 months. WebA trailing 12 months calculation is a type of analysis that looks at the previous 12 months financial data in your business. The formula i am using is =SUM (OFFSET (B6,0,MATCH (-1,B6:W6,-1)-1,1,-12)). WebRolling 12 Month Period means the 365 (or 366 when applicable) days immediately preceding any day the employee takes leave. The DSO figure on the KPI tile displays the total DSO figure for your company. We then multiply 15% by 365 days to get approximately 55 for DSO. then created the viz . SELECT * from table where customer = current_row customer and yearmonth >= current month - 12 and yearmonth