I've used ES2 to create a user entry form. On that form there are 12 questions and each question has a radio button with a scoring system from 1 to 6 on it. The user is asked to select a score from the radio button for all 12 questions and then at the bottom the form gives an average score. This all works great but the score doesn't round up to the nearest whole number so it's not as accurate as I would like it to be. Could anyone give me any pointers as to ways of fixing this issue? I have no experience on coding and this is the first time I've used ES2 so go easy with me, the formula I've used just adds up the scores from each of the radio button fields and then divides by 12 (that's the number of questions).
We have a WINNER!! Thanks very much. That works as expected, the only slight problem it may cause is for example: If I select 8no 3's, 1no 2's and 3no 1's. The calculation has added them all up to get 29 then divided by 12 to get 2.4 and so doesn't round up. However when you look at the sheet there are more three's than any other score so having the average score as 2 appears to be wrong, even though the calculation is correct. I'm not sure how the user wants it to appear so this may be fine but how would I go about changing the formula if we wanted to show the most selected answer instead of the average? For example; if no 3 was selected say 5 times compared to the other selections being less than 5 times, how we would show the score to be 3?
I've just changed the forumla to quickly include only 3 of the radio button values and have divided by 3 instead of the usual 12. I've then take the radio forms out of the sub-form to match the RBQ1 setup. This does something different but it's even more random in the way it rounds up. I've selected 1 for all 3 questions and the average is down as 2. I think select 1 and 1 and 6 and it comes back with an average score of 7.
I've customised each radio button to have a value of 1-6. I've gone through the menu's and cannot see anything that says 'null value' anywhere. The default value on them all is 1 unless the user selects another value. A screen shot of the form is below if that helps at all.
Thanks for your reply. I've just tried that but it's the same as it was before. I have to click on 9no 2's before it changes the average score from 1 to 2. I would expect the average score to change from 1 to 2 on the 7th questions as at that point there are 7 questions with a score of 2 and only 5 questions with a score of one.