I have two questions:
Question 1 - Text Entry - How many XX do you have?
Question 2 - Matrix Table (Constant Sum with Total) - How many XX do you have for each category below?
Red
Yellow
Blue
The Matrix Table displays a running Total row
I want to check that the Total at Question 2 matches the answer at Question 1.
Solved
In a Matrix Table how do I validate the Total against a previous question
+14Best answer by bstrahin
MikeW you can use the built in "Must Total" validation and pipe in the value from your first question. I used pipe text in the second question's wording to get the code I needed and then copy and pasted that code into the menu where it says Choices Must Total and it worked well for me. For question 1, make sure you validate that they are entering a number in the text box and force a response to that question to avoid issues.
+27In Q2 custom validation:
Red = {piped answer from Q1} - {piped answer for yellow} - {piped answer for green}
1 person likes this
+38MikeW you can use the built in "Must Total" validation and pipe in the value from your first question. I used pipe text in the second question's wording to get the code I needed and then copy and pasted that code into the menu where it says Choices Must Total and it worked well for me. For question 1, make sure you validate that they are entering a number in the text box and force a response to that question to avoid issues.
1 person likes this
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.