C
Carrie_Loos
I am really stuck. I have tried this a dozen different ways without results.
I want to take a simple query (Query has date formatted to month and a summed
quantity) and create a running average by 12 month groupings as well as
extend out to 6 months beyond for running average forecast; as shown below:
[The 12 Month Running Avg are my own calculations, this is where I am stuck]
Part Nbr Month SumOfOrd Qty 12 Month Running Avg
51009 Mar-06 8
51009 Apr-06 1
51008 May-06 1
51008 Jun-07 0
51008 Jul-07 0
51008 Aug-06 3
51008 Sep-06 0
51008 Oct-06 12
51008 Nov-06 2
51008 Dec-06 7
51008 Jan-07 10
51008 Feb-07 7 4
51008 Mar-07 9 4
51008 Apr-07 7 5
51008 May-07 5 5
51008 Jun-07 6
51008 Jul-07 6
51008 Aug-07 7
51008 Sep-07 7
51008 Oct-07 7
51008 Nov-07 8
I just don't know sequel well enough to get what I need. And if there is a
way to get standard deviation on the actuals vs forecast (12 month running
average), I would be thrilled. Currently I have to export to Excel for this
calculation. Can anybody help?
Thanks
Carrie
I want to take a simple query (Query has date formatted to month and a summed
quantity) and create a running average by 12 month groupings as well as
extend out to 6 months beyond for running average forecast; as shown below:
[The 12 Month Running Avg are my own calculations, this is where I am stuck]
Part Nbr Month SumOfOrd Qty 12 Month Running Avg
51009 Mar-06 8
51009 Apr-06 1
51008 May-06 1
51008 Jun-07 0
51008 Jul-07 0
51008 Aug-06 3
51008 Sep-06 0
51008 Oct-06 12
51008 Nov-06 2
51008 Dec-06 7
51008 Jan-07 10
51008 Feb-07 7 4
51008 Mar-07 9 4
51008 Apr-07 7 5
51008 May-07 5 5
51008 Jun-07 6
51008 Jul-07 6
51008 Aug-07 7
51008 Sep-07 7
51008 Oct-07 7
51008 Nov-07 8
I just don't know sequel well enough to get what I need. And if there is a
way to get standard deviation on the actuals vs forecast (12 month running
average), I would be thrilled. Currently I have to export to Excel for this
calculation. Can anybody help?
Thanks
Carrie