Welcome, Guest
Username: Password: Remember me

TOPIC: Array Numbers with Sum Validation

Array Numbers with Sum Validation 1 year 7 months ago #104368

  • chinaski
  • chinaski's Avatar
  • Offline
  • Junior Lime
  • Posts: 22
  • Thank you received: 1
  • Karma: 0
I want to do a Multiple Numeric Input question but as an array, like the Array Numbers question type, but where each column of answers sums to 100, as I can do with the Multiple Numeric Input. Is this possible?

To see what I mean, here is what it would look like



The "now" and "future" columns should sum to 100, no individual answer should be greater than 100 or less than 0.

Is this possible?

This message has an attachment image.
Please log in or register to see it.

The administrator has disabled public write access.

Array Numbers with Sum Validation 1 year 7 months ago #104374

  • TMSWhite
  • TMSWhite's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 759
  • Thank you received: 83
  • Karma: 37
Yes, you can do this easily.

Here is what it looks like running:



Here is the question design view:



For the help text, you enter the following:
Total Now = {sum(self.sq_now)}
Total Future = {sum(self.sq_future)}

and this expands internally to look like this:



Here is the actual question as a .lsq file

File Attachment:

File Name: limesurvey..._192.lsq
File Size:5 KB


The Expression Manager documentation explains how to use the self variable in more detail.

This message has attachments images.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

The administrator has disabled public write access.

Array Numbers with Sum Validation 1 year 7 months ago #104392

  • TMSWhite
  • TMSWhite's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 759
  • Thank you received: 83
  • Karma: 37
I neglected the requirement that that each value be between 0 and 100.

Here is the corrected question as .lsq file:

File Attachment:

File Name: limesurvey...8318.lsq
File Size:5 KB



And the associated screenshot showing that it works:



The rest is the same.

This message has an attachment image.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

The administrator has disabled public write access.
The following user(s) said Thank You: chinaski

Array Numbers with Sum Validation 1 year 6 months ago #105681

  • chinaski
  • chinaski's Avatar
  • Offline
  • Junior Lime
  • Posts: 22
  • Thank you received: 1
  • Karma: 0
Thanks for your replies to this and sorry for my late response. I didn't receive a notification that someone had responded to this thread.

I have tested out your question example and it does work very well.

Cheers.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.147 seconds