# Sum & validation in multiple numerical input question

1 año 3 meses antes #173247 por 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.

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

LimeSurvey Partners
1 año 3 meses antes #173255 por tpartner
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

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Official LimeSurvey Partner - partnersurveys.com
El siguiente usuario dijo gracias: vzyldd

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

1 año 3 meses antes - 1 año 3 meses antes #173257 por Joffm
Hi,
yes, you are.

sum(Q2_4)=<sum(Q2_1)

But why do you "sum"? This are single fields.

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
Última Edición: 1 año 3 meses antes por Joffm.
El siguiente usuario dijo gracias: vzyldd

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

4 meses 2 semanas antes #186706 por l1bxr02
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)}

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

4 meses 2 semanas antes #186711 por Joffm
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

"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
El siguiente usuario dijo gracias: DenisChenu

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

## ¡Comenzar ahora!

#### Simplemente cree una cuenta y comience a usar LimeSurvey hoy mismo.

¡Únase a nuestro boletín informativo!