0

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?

  • Can you include some example data and example output? – Aron Foster Feb 2 '15 at 17:42
  • Sure, on one entry the value for Q1 Rating is 1 and the rest are 4s (one field = 1, eleven fields = 4) but the calculated average returned is 4 instead of 3.75. – Jennifer Feb 2 '15 at 19:10
  • Sorry if this is a dumb question, but in your calculated field properties is it set up to only show one digit? – Aron Foster Feb 2 '15 at 19:22
  • No, I have it set to show up to two decimals :) On other entries it is showing more than one digit but its still wrong. Example entry: three = 1, six = 2, six = 3, three = 4 with a returned average of 3.33 instead of 2.5 – Jennifer Feb 2 '15 at 19:28
  • I've never seen that problem before. Does the order affect the calculated value? If you use =SUM(...)/12 does the error remain? – Aron Foster Feb 2 '15 at 19:36
1

Validate all your 12 fields are actually numbers with

=ISNUMBER([Q 1 Ratings]) 
& ISNUMBER([Q 2 Ratings]) 
& ISNUMBER([Q 3 Ratings]) 
& ISNUMBER([Q 4 Ratings]) 
& ISNUMBER([Q 5 Ratings]) 
& ISNUMBER([Q 6 Ratings]) 
& ISNUMBER([Q 7 Ratings]) 
& ISNUMBER([Q 8 Ratings]) 
& ISNUMBER([Q 9 Ratings]) 
& ISNUMBER([Q 10 Ratings]) 
& ISNUMBER([Q 11 Ratings]) 
& ISNUMBER([Q 12 Ratings])

It should return TRUETRUETRUE....TRUE

if there is a FALSE in the string you've got a Text field instead of Number

0

The best option would be to use a SP view.

Modify the view. Under the Totals section, select Average for the desired column.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.