Guys and girls,
I have created a table from which I need to create a 3mth Moving Average and a 12 Month Moving Average.
One complication is that there are months which may have 0 in Average.
I have looked at the "Hospital Ranking" example and the VB Function example in prior posts and have tried to modify both to my needs with no success.
Is there an expression I use to make a 3rd and 4th column, being the 3mth and 12 mth avg.
My table looks like this
Period Avg
30/09/2003 14629
31/10/2003 14562
30/11/2003 0
31/12/2003 0
31/01/2004 0
28/02/2004 565
31/03/2004 0
30/04/2004 0
31/05/2004 0
30/06/2004 11346
31/07/2004 8303
30/08/2004 11595
Thanks for your effort, my head is spinning
Tony
I have created a table from which I need to create a 3mth Moving Average and a 12 Month Moving Average.
One complication is that there are months which may have 0 in Average.
I have looked at the "Hospital Ranking" example and the VB Function example in prior posts and have tried to modify both to my needs with no success.
Is there an expression I use to make a 3rd and 4th column, being the 3mth and 12 mth avg.
My table looks like this
Period Avg
30/09/2003 14629
31/10/2003 14562
30/11/2003 0
31/12/2003 0
31/01/2004 0
28/02/2004 565
31/03/2004 0
30/04/2004 0
31/05/2004 0
30/06/2004 11346
31/07/2004 8303
30/08/2004 11595
Thanks for your effort, my head is spinning
Tony
