Moving Average From Beginning to Now...
Posted: Thu Jun 06, 2019 10:52 am
I have a monthly time series for which I need a rolling average. The average should run from the first value in the time series up to the current value, but not include any values from future dates beyond the current date on which the average is being calculated.
Date Value Average (Beginning - Current)
2012m01 5.00 5.00
2012m02 6.00 5.50
2012m03 7.00 6.00
2012m04 8.00 6.50
2012m05 9.00 7.00
The above example is an idea what I'm trying to figure out how to do...
Kevin
Date Value Average (Beginning - Current)
2012m01 5.00 5.00
2012m02 6.00 5.50
2012m03 7.00 6.00
2012m04 8.00 6.50
2012m05 9.00 7.00
The above example is an idea what I'm trying to figure out how to do...
Kevin