- Posts: 38
- Thank you received: 0

- Community
- Forums
- English support forums
- Can I do this with LimeSurvey?
- Sum & validation in multiple numerical input question

# Sum & validation in multiple numerical input question

11 months 3 weeks ago #173247
by vzyldd

*Sum & validation in multiple numerical input question*was created by

*vzyldd*

Hi, need a little guidance please.

I'm using a multiple numerical input question but needs to validate the totals of the different sub-questions individually.

I need to check that the answer in sub-question 1 equals the sum of sub-question 2 and 3. Check that sub-question 4 is not more than the answer in sub-question 1.

I tried the validation in the sub-question validation box but somewhere I'm missing the target. I've used the following:

sum(Q2_4)=<sum(Q2_1) but are not sure if I am on the right track.

I'm using a multiple numerical input question but needs to validate the totals of the different sub-questions individually.

I need to check that the answer in sub-question 1 equals the sum of sub-question 2 and 3. Check that sub-question 4 is not more than the answer in sub-question 1.

I tried the validation in the sub-question validation box but somewhere I'm missing the target. I've used the following:

sum(Q2_4)=<sum(Q2_1) but are not sure if I am on the right track.

Please Log in or Create an account to join the conversation.

Less
More

- Posts: 8247
- Karma: 621
- Thank you received: 2509

11 months 3 weeks ago #173255
by tpartner

Replied by

*tpartner*on topic*Sum & validation in multiple numerical input question*
I would think the question validation equation would be something like:

`{Q2_1 == sum(Q2_2, Q2_3) && Q2_4 <= Q2_1}`

*Cheers,*

Tony Partner

Tony Partner

*Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.*

*Official LimeSurvey Partner - partnersurveys.com*

The following user(s) said Thank You: vzyldd

Please Log in or Create an account to join the conversation.

11 months 3 weeks ago - 11 months 3 weeks ago #173257
by Joffm

Replied by

*Joffm*on topic*Sum & validation in multiple numerical input question*
Hi,

yes, you are.

So it is something like:

(Q2_1==sum(Q2_2,Q2_3) AND (Q2_1>=Q2_4)

And the tip could be:

{if(Q2_1!=sum(Q2_2,Q2_3),"Sum not equal Total","")}

...

But you have to add something that allows empty fields. Otherwise you will see the red border if "Total" is filled, but "boys" and "girls" still empty. Of course the sum is not equal in this case.

Best regards

Joffm

yes, you are.

But why do you "sum"? This are single fields.sum(Q2_4)=<sum(Q2_1)

So it is something like:

(Q2_1==sum(Q2_2,Q2_3) AND (Q2_1>=Q2_4)

And the tip could be:

{if(Q2_1!=sum(Q2_2,Q2_3),"Sum not equal Total","")}

...

But you have to add something that allows empty fields. Otherwise you will see the red border if "Total" is filled, but "boys" and "girls" still empty. Of course the sum is not equal in this case.

Best regards

Joffm

*Volunteers are not paid.*

Not because they are worthless, but because they are priceless

Not because they are worthless, but because they are priceless

Last edit: 11 months 3 weeks ago by Joffm.

The following user(s) said Thank You: vzyldd

Please Log in or Create an account to join the conversation.

1 month 3 days ago #186706
by l1bxr02

Replied by

*l1bxr02*on topic*Sum & validation in multiple numerical input question*
Hello there

This is what I am trying to do.

4.A.(1)

(2)

4.B. (1)

(2)

(3)

4.C. Sum of 4.A(1) through 4.B(3)

Is this equation correct? Am I missing something?

{4.C = sum(4.A.(1), 4.A.(2)) AND sum(4.B.(1),4.B.(2),4.B.(3)}

This is what I am trying to do.

4.A.(1)

(2)

4.B. (1)

(2)

(3)

4.C. Sum of 4.A(1) through 4.B(3)

Is this equation correct? Am I missing something?

{4.C = sum(4.A.(1), 4.A.(2)) AND sum(4.B.(1),4.B.(2),4.B.(3)}

Please Log in or Create an account to join the conversation.

1 month 3 days ago #186711
by Joffm

Replied by

*Joffm*on topic*Sum & validation in multiple numerical input question*
Now you ask the same question in three really outdated posts.

Would be better you open a new post with an attached sample of your survey (*.lss) with the relevant questions.

I assume 4A and 4B are two questions of type multiple numerical input.

And if you'd read the manual here

https://manual.limesurvey.org/Expression_Manager_-_presentation#Qcode_variable_naming

and

https://manual.limesurvey.org/Expression_Manager_-_presentation#The_reserved_.22this.22.2C_.22self.22.2C_and_.22that.22_variables

Having read this

you know that your equation has to look like this:

{sum(QuestionCode_SubQuestionCode1,QuestionCode_SubQuestionCode2,QuestionCode_SubQuestionCode3,...)}

If you can use the "that"-variable you can shorten to

{sum(that.QuestionCode)}

Joffm

Would be better you open a new post with an attached sample of your survey (*.lss) with the relevant questions.

I assume 4A and 4B are two questions of type multiple numerical input.

And if you'd read the manual here

https://manual.limesurvey.org/Expression_Manager_-_presentation#Qcode_variable_naming

and

https://manual.limesurvey.org/Expression_Manager_-_presentation#The_reserved_.22this.22.2C_.22self.22.2C_and_.22that.22_variables

Having read this

"Here are the details of how to construct a Qcode (and access some properties) by question type. In general, Qcodes are constructed as:

QuestionCode . '_' . SubQuestionID . '_' . ScaleId"

you know that your equation has to look like this:

{sum(QuestionCode_SubQuestionCode1,QuestionCode_SubQuestionCode2,QuestionCode_SubQuestionCode3,...)}

If you can use the "that"-variable you can shorten to

{sum(that.QuestionCode)}

Joffm

*Volunteers are not paid.*

Not because they are worthless, but because they are priceless

Not because they are worthless, but because they are priceless

The following user(s) said Thank You: DenisChenu

Please Log in or Create an account to join the conversation.