trying to compute mean based on previous rows' values (need to retrieve historic values)
Hi - I am trying to figure out how to get jsl to retrieve prior rows' values (values from previous 4 rows) to use in a formula to compute the mean of those rows. For example, let's say my column A has the following values 3,3,2,8,0,2,2. I'd like the formula in column B to compute the mean of column A using values from its prior 4 rows. The mean function is straightforward but having I haven't...