Hello
In my survey I have a number of questions that are labeled with text and then categorized in the from 0 to 3 in the name column in the choices worksheet of my xls form.
I am trying to add up these categorized values to get a total site score and have created a hidden value using a calculation for each of these questions using the "+" sign between each of the questions. When I test this out, I am getting wild answers. The total should add up to no more than 15, five categorized questions with a max value of 3, but I am getting valued in the 10,000s.
Is it possible that it is not working because I have categorized numerically text based names that are used for the answers? If so, is there a workaround for this in the form, or is it something that I have to do outside of Survey123 post data collection?
Thanks
Yes this comes up a lot on the board. Since it is string it is concatenating instead. Set the bind::type field to int for all the questions. Or you can use number() around each value in the line you are adding them up on.
Great
That worked for me.
Thanks so much.