
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 09, 2020 11:30 AM
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?
2 Replies 2

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 09, 2020 12:49 PM
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.
Reply

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 10, 2020 08:37 AM
Yes, use a formula looking something like this
Average({Week 1}, {Week 2},…)
