Hi!
I have a matrix table that features to columns and three rows. Each constant sum box gives the respondent the opportunity to input a %. Is there a way to enforce all constant sum boxes across both columns and rows to "Must Total" 100? I see options for columns only or rows only total 100, but I want every constant sum box to add up to 100.
This may be an easy question, so apologies for this. What is the best way to do this?
Thanks,
Luke
Question
How to ensure all constant sum boxes across rows and columns to total 100
+22You can use custom validation.
For eg you have 3*3 matrix table, then in order to validate first row to 100 apply validation as - select statement 1 - Scale point 1 is equal to $e{ 100 - ( q://QID365/ChoiceNumericEntryValue/1/2 + q://QID365/ChoiceNumericEntryValue/1/3 ) }
q://QID365/ChoiceNumericEntryValue/1/2->select statement 1 -Scale point2 q://QID365/ChoiceNumericEntryValue/1/3-> select statement 1 - Scale point 3
Similarly you need to perform for all rows and all columns.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.