cancel
Showing results for
Did you mean:  Helper V

Help with a formula

Hey all

I just need some help with this formula. I am trying to get the average of 3 different columns in a data table.

Here is the formula and credit at @WarrenBelz for helping me put it together -

"Average = " &
With(
{
wList:
Filter(
'Daily Measurement',
'Daily Measurement(Views)'.'Active Daily  Measurement',
'Count'.'Counts'=GalleryList.Selected.'Count'.'Counts'
)
},
Average(
wList,
'1 Count Column', '2 Counts Column', '3 Counts Column')
)

This part here is giving me the trouble -

Average(
wList,
'1 Count Column', '2 Counts Column', '3 Counts Column')
)

It doesnt let me use multiple columns in this case. How can I make it so that I can use all 3 columns and get the average of all 3 instead of just 1 column?

Thank you and kind regards.

1 ACCEPTED SOLUTION

Accepted Solutions  Resolver I

Average function can't be used with multiples columns of a collection. A workaround would be to calculate the average line by line and then the average of line average, like this:

Average(wList, Average('1 Count Column', '2 Counts Column', '3 Counts Column'))  Resolver I

Average function can't be used with multiples columns of a collection. A workaround would be to calculate the average line by line and then the average of line average, like this:

Average(wList, Average('1 Count Column', '2 Counts Column', '3 Counts Column'))  