Hi Ben
On Tue, Nov 15, 2011 at 16:21, Benjamin Beckwith wrote:
> #+TBLFM: $2=if(@# >=7, vmean(@-5$1..@0$1),string(""));
The above does not work because the range expression "@-5$1..@0$1" is
an Org construct and has to be evaluated for every affected row
already in Org, before it is given to Calc
Benjamin Beckwith wrote:
>
> I'm trying to create a table of periodic data and calculate a moving
> average in an adjacent column. I was trying to use field coordinates,
> but they do not work how I would like them to work.
>
> Here is what I have for a 5-day moving average:
>
> | Daily Data
I'm trying to create a table of periodic data and calculate a moving
average in an adjacent column. I was trying to use field coordinates,
but they do not work how I would like them to work.
Here is what I have for a 5-day moving average:
| Daily Data | Moving Average |
|+--