AVERAGE FORMULA

Susan van Niekerk

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

@Georgie

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

Hello @Susan van Niekerk,

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

Hi @Protonsponge

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

but yes the Site were predetermined drop down option

Georgie

Hey @Susan van Niekerk,

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

@Georgie

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))