Calculating the average of numbers in a column that updates as the data changes

Ask for Help
1

Hi All,

I would like to be able to calculate the ‘average’ of a column that updates as data is changed in the rows…any ideas how I can set this up?

Thanks in advance, Simon

Hi All, I would like to be able to calculate the 'average' of a column that updates as data is changed in the rows...any ideas how I can set this up
Hi All, I would like to be able to calculate the 'average' of a column that updates as data is changed in the rows...any ideas how I can set this up1414×2000 97.7 KB

2

Create a new rollup column, and target it at your Overall Average column, taking the average.

1 Like
3

Thanks Darren,

I think that might work :grinning: