AVG(COLLECT(question

Shannon Scarbrough

Hi!

I want to take the average score of a column (which uses the star symbols on a 1-5 ranking system), when another column has a specific provider listed.

My formula looks like this but I'm getting unparseable. =AVG(COLLECT({Master Provider Scorecard Range 1}, {Master Provider Scorecard Range 2}, "Provider A"))

L_123

you can't average a boolean expression, instead try adding a helper column with a stacked if statement to convert the symbols to integers, then average the integers.

*or you can use stacked countifs to avoid the helper column