I have a survey with a series of 10 questions, each question has 2 choices. The choices are specific to the question, but are related in a fashion - 1 response is related to group 1 the other related to group 2. I need to tally the number of responses that relate to each group and display the values (i.e., group 1 = 4, group 2 = 6).
Any help would be most appreciated.
Are they 10 questions or one question in a repeat?
If 10 questions it will be some work.
Add 2 hidden fields with a calculation of if(group1value,1,0) then make sure to set the bind:type column to int. Second one is if(group2value,1,0)
Then make a final field to add all 10 of the above fields up. So q1count+q2count+etc bind this to int also.
If you are using a repeat then its easier.
Add 2 hidden fields with a calculation of if(group1value,1,0) then make sure to set the bind:type column to int. Second one is if(group2value,1,0)
Then make a final field to add all 10 of the above fields up. But not all you need is sum(q1count) and sum(q2count). bind this to int also.