Adding up a row must not exceed 100.

walliwalli GermanyCommunity Member Qubie ✭

Adding up a row must not exceed 100.

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?

Tagged:

Best Answer

  • TomGTomG Raleigh, NC Wizard ✭✭✭✭✭
    Accepted Answer

    @walli,

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

Answers

  • ysm1nzysm1nz New ZealandCommunity Member - Trial User Qubie ✭

    You could do it using custom javascript validation

  • walliwalli GermanyCommunity Member Qubie ✭

    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!

Sign In to Comment