Hoping someone might be able to help me with some survey flow calculations. I’ve tried numerous iterations and nothing seems to work!
I have a set of 7 statements in a grid with 5 options each. These 5 options are recoded as:
1 = 0
2 = 25
3 = 50
4 = 75
5 = 100
Respondents can elect to answer all or only a portion of the statements.
A total score needs to be calculated which is the sum of all the recoded values, divided by how many statements they answered.
e.g. Respondent answers statements 1, 3, 4, 7 with the recodes
Statement 1 = 25
Statement 3 =100
Statement 4 = 0
Statement 7 = 75
(summing to 200).
The respondent answered 4 out of the possible 7 statements, therefore the calculated score is 200 / 4 = 50.
I’ve followed the advice on arithmetic operations on the Qualtrics website and tried multiple different methods of creating embedded data fields. The Branch IF Field = Empty in the survey flow doesn’t appear to work - if it did it would solve all my problems!
Hoping someone might have a good idea I could try.