AVERAGE FORMULA

Susan van Niekerk · 01/10/25

Hi Guys

I have a survey building - we want to average the Planning Column for each specific site

I have tried a couple ways, and cant get it to work

Susan van Niekerk · 01/15/25

no problem, it was quire simple once I calmed down and thought it through

I wanted an average per specific column( which are questions in survey) per site

=AVG(COLLECT({Plan}, {SITE}, [Primary Column]@row))

Protonsponge · 01/10/25

Can I just clarify your question… are you looking to average the values in the [Planning] column if it is equal to the [Site] name?

In your use case, does the site name repeat throughout the [Site] column?

Protonsponge

Susan van Niekerk · 01/14/25

I managed to figure out a formula that will work, thank you

but yes the Site were predetermined drop down option

Georgie · 01/15/25

I'm glad you got this resolved! Would you be happy to post the formula that works to help other members reviewing this thread?

Thanks,

Georgie

Susan van Niekerk · 01/15/25

no problem, it was quire simple once I calmed down and thought it through

I wanted an average per specific column( which are questions in survey) per site

=AVG(COLLECT({Plan}, {SITE}, [Primary Column]@row))

Best Answer