I need to make a matrix table that adds all selected values for the statements, but ignores two specific non number values that are available for each statements drop down list. the sum of all the values must not exceed 100. If the sum is greater than 100, it must have a validation error or similar pop up to prevent the respondent from continuing. I am fully lost in the best way to approach this problem.
Validation with ignored selected choices
+27SRL ,
Add a text entry question after the matrix question. Add JS to your matrix question to sum the values and copy the sum to the text entry question. Add custom validation to the matrix question based on the value of the text entry question.
You probably need to display the current sum to the respondent. There are a number of different approaches. If it were me, I would hide the text entry question and add html via JS to the matrix question to display the sum.
+16Wow! Great job on providing a solution to a unique question! 👏
+27https://community.qualtrics.com/XMcommunity/discussion/comment/50921#Comment_50921While SRL's situation is unique, the validation need isn't. I've used this technique quite a few times.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.