4 years 10 months ago #91391 by Gabriela
Hi all,

Have 2 array numbers questions.
First array numbers question asks how many chidren (ages and sex) there are?
Second question asks how many, of these children, (ages and sex) go to school?

based on the totals of the first array numbers question, how can I prevent the totals of the second array numbers question is bigger then the totals of the first one? ..
(hope im being clear and not 2 anoying...)

thanks a lot.

G.

4 years 9 months ago #91394 by tpartner
Gabriela, are both questions in the same group? If so, can you attach a sample group?

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

4 years 9 months ago #91402 by Gabriela
hi, thanks,
yes, they are,

I want to prevent that totals of "Nº de crianças produtoras de programas escolarizadas" (third question) is greater than totals of "Nº de crianças produtoras de programas" (first question)
(a message appears saying its wrong and cant continue,or something like that..). The survey is group by group.

attaching...

thanks A LOT.

G
##### Attachments:

4 years 9 months ago #91405 by TMSWhite
Gabriela-

For the 3rd question, use the following for the advanced question option "Question validation equation":
`sum(self) <= sum(that.numcriancas)`

And for "Question validation tip", use something like:
`The sum of values for this question must not be greater than that for the first question.`
.

When you use "Show Question Logic", you will see the following formula, which is automatically generated from the equation sum(self) <= sum(that.numcriancas)
`sum(numescolarizadas_A_1, numescolarizadas_A_2, numescolarizadas_B_1, numescolarizadas_B_2, numescolarizadas_C_1, numescolarizadas_C_2) <= sum(numcriancas_A_1, numcriancas_A_2, numcriancas_B_1, numcriancas_B_2, numcriancas_C_1, numcriancas_C_2)`

4 years 9 months ago #91406 by Gabriela