I have designed a survery/questionaire in InfoPath and have it publishing to SharePoint 2010. I used option buttons (whole number integer) to allow the users to select a rating for each question (values 1-4). I am trying to get the average rating (per survey) to calculate in the SharePoint list but it is not returning the correct average.
Here is the formula I'm using:
=AVERAGE([Q 1 Ratings],[Q 2 Ratings],[Q 3 Ratings],[Q 4 Ratings],[Q 5 Ratings],[Q 6 Ratings],[Q 7 Ratings],[Q 8 Ratings],[Q 9 Ratings],[Q 10 Ratings],[Q 11 Ratings],[Q 12 Ratings])
Any ideas of what I may have done wrong?

0 commentaires:
Enregistrer un commentaire