+14
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.
Best answer by bstrahin
View original
+27
In Q2 custom validation:
Red = {piped answer from Q1} - {piped answer for yellow} - {piped answer for green}
+38
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.