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 | |------------+----------------| | 10 | | | 11 | | | 12 | | | 13 | | | 14 | | | 14 | | | 16 | | #+TBLFM: $2=if(@# >=7, vmean(@-5$1..@0$1),string("")); I expeced the if(@# >=7..) to protect the sub-clauses from executing unless the predicate is true. However, that is not the case. When I try to execute this formula, I receive the error: "Row descriptor -5 used in line ### leads outside table". I can see how this is true if the ranges are checked for every entry. Is there a better way for me to write this column forumla? Is this a limitation in the field coordinates? Thanks, Ben