Constant sum "must total" validation option where the total equals the response to previous q? | XM Community
Solved

Constant sum "must total" validation option where the total equals the response to previous q?

  • 13 May 2020
  • 2 replies
  • 275 views

Userlevel 1

Hello all,
I am building a survey where I need a specific validation option that I am having trouble figuring out. We will be asking the number of people their family, and then in the next question we want to use a constant sum question so participants can enter the number of people in their family that fall in to a specific age category. Below I have put a screenshot of what I these questions look like. I want the total for Q230 to have validation such that the total must equal the numeric response provided in Q228. Entering the piped text into the validation does not work.
I have found this: https://www.qualtrics.com/community/discussion/2715/constant-sum-must-total-question. I can get this to work but only if there are 7 response options in the table. The JS for the HOLD TOTAL question doesn't seem to be holding any information about the number of response to sum, at least not that I can tell. Does anyone have any ideas what the issue might be? Or have a different solution? Thank you!

Screen Shot 2020-05-13 at 3.04.32 PM.png

icon

Best answer by rondev 13 May 2020, 23:31

View original

2 replies

Userlevel 7
Badge +22

With reference to the survey present over here - https://www.qualtrics.com/community/discussion/2715/constant-sum-must-total-question:
Every thing would remain same (you can make the Q2 to 5 row as you require) except the custom validation at Q2 will have only first condition as shown below:
image.png

Userlevel 1

That worked! Thank you so much!

Leave a Reply