How to apply a column formula on only a range of rows and not every row?

AC_AC — Sat, 10 Jun 2023 23:51:05 GMT

Hi,

I am trying to create a column formula that calculates the mean of every 5 rows (for a specific column).

Normally the formula are applied to every row using values in such row. Instead, I would like to use values from 5 previous row to calculate a mean value.

I am been playing with the formula editor and try to use the Row() and other functions, but without success.

Thanks a lot to anyone who can help me out.

AC_AC

Re: How to apply a column formula on only a range of rows and not every row?

jthi — Fri, 15 Jul 2022 11:03:50 GMT

For Mean I would suggest using Col Moving Average

If(Modulo(Row(), 3) == 0,
	Col Moving Average(:Col, 1, 2, 0),
	.
)

Otherwise might be helpful

If(Modulo(Row(), 3) == 0,
	Mean(:Col[Index(Row() - 2, Row())])
)

topic Re: How to apply a column formula on only a range of rows and not every row? in Discussions

How to apply a column formula on only a range of rows and not every row?

Re: How to apply a column formula on only a range of rows and not every row?