http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Wed, 01 Apr 2009 21:33:24 +0000 http://www.endusersharepoint.com/STP/topic/modifymanipulate-survey-results-1#post-5488 Mon, 30 Mar 2009 06:47:57 +0000 Toni 5488@http://www.endusersharepoint.com/STP/ <p>The problem is SharePoint stores each answer to such question in the following format:</p> <p>1) selected_option1#;selected_option7<br /> 2) selected_option2#;selected_option4<br /> etc.</p> <p>And the results display exactly that, each combination one line... :(((</p> <p>There is no easy way to solve this. Options: Excel or custom programming. In your case I would Excel and count the values... </p> <p>=COUNTIF([COLUMN], "selected_option1")<br /> =COUNTIF([COLUMN], "selected_option2")<br /> =COUNTIF([COLUMN], "selected_option3")</p> <p>etc. </p> http://www.endusersharepoint.com/STP/topic/modifymanipulate-survey-results-1#post-5469 Fri, 27 Mar 2009 16:22:09 +0000 eakawie 5469@http://www.endusersharepoint.com/STP/ <p>Is there a way to modify the standard Graphical Summary from a survey? I've got a bunch of questions where the users answer with checkboxes, and the Summary displays each permutation as a seperate line, so if someone answers "A and B", it shows up as one line, and a response of "B and C." I'd like totals of each answer, so I would see A=1 B=2 C=1.</p> <p>I know I can export to Excel and manipulate there, but my boss doesn't quite accept that as the only solution. </p>