Hi everyone,
I am asking a constant sum question in a survey. One column needs to equal 100% while the other two columns need to equal a particular sum.
I cannot figure out how to provide custom validation for this question. Does anyone have ideas? Also, I need to add force response to this question as well. 
Thank you!
Matrix, constant sum, custom validations
Userlevel 3
+8
Userlevel 7
+22
We need to use custom validation here.
For example the custom validation for first column sum = 100 will be:
option A_Percentage = $e{ 100 - ( option B_Percentage + option C_Percentage ) }
So in the custom validation pop up, in the last box, you can put the math operation as shown above, which will be similar to below
option A_Percentage equal to $e{ 100 - ( q://QID505/ChoiceNumericEntryValue/2/1 + q://QID505/ChoiceNumericEntryValue/3/1 ) }
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.