2 Month or Quarter Rolling average
Hi Folks
I have been struggling with this issue.
I have a series of invoices, recorded in an Invoice table. These are summarized by reporting quarter in a parent table. From this one is able to see the various types of spend as a percentage of total spend per quarter.
The next step is that we need to look at the rolling average of current quarter and previous quarter as a percentage of a target. The quarters are linked to defined dates.
The requirement is as follows:
Average spend for Q1 plus average spend percentage for Q2. Then the average spend percentage for Q2 and Q3. This continues over 80 quarters.
Does anyone have any pointers on how to do this?
Thank you
------------------------------
Matthew Kearns
------------------------------
I have been struggling with this issue.
I have a series of invoices, recorded in an Invoice table. These are summarized by reporting quarter in a parent table. From this one is able to see the various types of spend as a percentage of total spend per quarter.
The next step is that we need to look at the rolling average of current quarter and previous quarter as a percentage of a target. The quarters are linked to defined dates.
The requirement is as follows:
Average spend for Q1 plus average spend percentage for Q2. Then the average spend percentage for Q2 and Q3. This continues over 80 quarters.
Does anyone have any pointers on how to do this?
Thank you
------------------------------
Matthew Kearns
------------------------------
