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; } } }

468424_en-US

liliconcom

Formula for calculating averages of values in two consecutive rows

I would like to calculate averages of two consecutive values in separate rows and I have table with 1000 rows. What formula can I use to do this?

Thanks

Analytics

Data Table

Re: Formula for calculating averages of values in two consecutive rows

The previous posted option will work great. You might also consider the Lag() function within the Mean() formula to reference the previous row, so it would read something like the below:

Mean( :Column, Lag( :Column ) )

Re: Formula for calculating averages of values in two consecutive rows

I think Col Moving Average should be able to do it Col Moving Average (jmp.com help)

From scripting index:

Comments

There are no comments yet