Adding up a row must not exceed 100. | XM Community
Skip to main content
Solved

Adding up a row must not exceed 100.

  • January 16, 2020
  • 3 replies
  • 167 views

Forum|alt.badge.img+2
  • Level 1 ●
  • 12 replies
Hi there, I am trying the following: I have four statements (rows) and two columns in which the respondents are supposed to allocate a share. The sum of each row shall not exceed 100, but it should be possible that it stays below 100. So far, I only figured out that I can set a "Must total 100" in constant sum questions, but this is not really what I am looking for, as it shall be possible for the participants to allocate less than 100. Am I overlooking a question type or validation that could solve this? !

Best answer by TomG

@walli, To avoid JS, add an 'Other' column that will be the difference between the first two columns and 100.

3 replies

  • 2 replies
  • January 17, 2020
You could do it using custom javascript validation

Forum|alt.badge.img+2
  • Author
  • Level 1 ●
  • 12 replies
  • January 17, 2020
Thanks for your response! I was afraid that it must be done via JavaScript, and unfortunately , all the coding that I am using in my survey stems from this board, as I have never learned how to code. Do you know how this could be done, @ysm1nz ? Or maybe someone else? Thanks a lot!

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 6083 replies
  • Answer
  • January 17, 2020
@walli, To avoid JS, add an 'Other' column that will be the difference between the first two columns and 100.