Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: How to get an average for multiple columns

2302 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dean_Toland
6 - Interface Innovator
6 - Interface Innovator

I’m helping a friend create a base to be used for tracking scores at local dance competitions but have trouble figuring out how to get a proper average for each record. Each line will have a different dance, and each one will have anywhere from 3-5 scores entered, so what we need is the Average Score column to average the input records. Anyone have suggestions on the best way to do this?

image.png

Keep in mind, in this instance there are only 4 judges, other competitions might have 5 and might have 3, so if possible it’d be nice to only average input values, not all 5 columns divided by 5. The correct average here would be 98 but the average of 5 scores (with the 5th empty) would be 78.4 and that would skew the info heavily.

Thanks!

10 Replies 10

So I am trying to get the average of 5 single-select fields. I’ve tried the formula several times and it’s not working.

Hi Jeremy, I hope you can help me. This is the formula that I am using to get the average of the 5 single-select columns and output them into another column.

AVERAGE({Responsiveness}, {Proactiveness},{Deadlines},{Platforms},{Problem Solving}, SWITCH({Responsiveness}, {Proactiveness},{Deadlines},{Platforms},{Problem Solving},".5",5 ,“1” ,1 ,“1.5” ,1.5 ,“2” ,2 ,“2.5” ,2.5 ,“3” ,3 ,“3.5” ,3.5 ,“4” ,4 ,“4.5” ,4.5 ,“5” ,5 ,“5.5” ,5 ,“6” ,6 ,“6.5” ,6.5 ,“7” ,7))