Check between automatictotal and manually filled total

Hello everyone...

I am a new user of ODK. Actually, I want to check total children q1=1(daughter) and q2=2(Sons) the total variable is q3=3(Total). Please help me how to check between q1+q2=q3 if manually input data q3=5 wrongly. I have idea of to make total of q1+q2 but i couldn't check such problem.

Could you please help me to solve the problem.

Thank you,

Dev, Nepal

Hi Dev from Nepal,

I find that phones do math better than people, so I don't let users
enter the total! Just have the form calculate it and show it to them.
I usually use a calculate question with "${q1} + ${q2}" as the
calculation.

The trick here is that if your inputs are not required, a user might
leave q1 or q2 blank and that will cause the calculation to fail. So
either have all inputs be required or use something like
"if(${q1}!='',${q1},0) + if(${q2}!='',${q2},0)" to set a default value
of 0 when q1 or q2 is blank.

I've attached an example.

Yaw

sum.xlsx (10.8 KB)

ยทยทยท On Mon, Sep 12, 2016 at 5:06 PM, wrote: > Hello everyone... > > I am a new user of ODK. Actually, I want to check total children q1=1(daughter) and q2=2(Sons) the total variable is q3=3(Total). Please help me how to check between q1+q2=q3 if manually input data q3=5 wrongly. I have idea of to make total of q1+q2 but i couldn't check such problem. > > Could you please help me to solve the problem. > > Thank you, > > Dev, Nepal > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.