nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

521744_en-US

liliconcom

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

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

Data Table

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of