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?