I'm not a wiz at math and this problem has me a little stumped. I need the average score out of 5 but it's a little different how I do it.
I have 5 fields, field one is rating one, field two is rating two, all the way up to field 5.
I need to grab the average of all these fields together, this is currently what I have.
Sorry, it's in programming syntax
round((($rating_one / 5) + ($rating_two / 5) + ($rating_three / 5) + ($rating_four /5) + ($rating_five / 5) / 5));
So I divide each field by 5, and add them together and then divide the total amount of the fields for the average. The problem is I need it to be 1-5, and I keep getting 109.
Here are the numbers in the fields
13 432 42 33 23
What am I doing wrong? If you need more details, I'll happily provide (or try) more.