Average percent formula help!

Topic Labels: Formulas
1307 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi! I need a formula to calculate the average of the previous 4 weeks %. Screenshot attached. Does anyone know what I would need to put in for that?

I’m assuming the July overall column needs to be a formula, right?

Screen Shot 2020-07-09 at 2.29.58 PM

2 Replies 2

The summary headers are to summarize rows (records), but you’re trying to summarize columns (fields).

You need to create a formula field using the AVERAGE function.

8 - Airtable Astronomer
8 - Airtable Astronomer

Yes, use a formula looking something like this
Average({Week 1}, {Week 2},…)