Skip to main content

Average percent formula help!

  • July 9, 2020
  • 2 replies
  • 29 views
K

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

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • July 9, 2020

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.

    P
    Forum|alt.badge.img+18
    • Paul_Warren
    • Inspiring
    • July 10, 2020

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

    Terms & ConditionsAccessibility statement