Skip to Content
0
May 15, 2020 at 07:05 PM

Calculate Avg based on a list

64 Views

Hello,

I have a report returning several fields (ID, sport, state, region, and score) with each having multiple options. I want to get the avg score for specific sports across all regions but I keep getting multivalue error. The calculation is:

=IF([SPORT] InList("Baseball"; "Football"; "Golf"); Avg([SCORE]))

Any ideas what the issue is?