Calculation and logic validation

[stelio]

Hello experts!
may you help me please? I have this extract:

1. How many people currently live in this Household? ______ Total members in the household.
2. How many of the MALE?
3. How many are FEMALE?

I’m facing difficulties in calculating and doing a validation. I need to compare the value of question 1 with the sum of questions 2 and 3. the number entered in question 1 must equal the sum of 2+3.

Calculation and logic validation

Hello experts! may you help me please? I have this extract: How many people currently live in this Household? ______ Total members in the household. How many of the MALE? How many are FEMALE? I’m facing difficulties in calculating and doing a validation. I need to compare the value of question 1 with the sum of questions 2 and 3. the number entered in question 1 must equal the sum of 2+3. https://community.kobotoolbox.org/t/calculation-and-logic-validation/33461?u=stelio

[wroos]

Welcome @stelio,
You may always give the search function of this forum a chance, please, e.g. https://community.kobotoolbox.org/search?context=topic&context_id=33461&q=total%20male%20female&skip_context=true

[stelio]

Thanks @wroos
I don’t know if I did it correctly…

[Kal_Lam]

@stelio, this post discussed previously should help you solve your issue:

How to validate the female and male entries with the total entry

Hi @Sylvain_DOAMBA, Simply expanding what @stephanealoo has advised. In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: (wrong entry) [Image 2] Data entry screen as seen in Enketo: (wrong entry) [Image 3] Data entry screen as seen in Enketo: (correct entry) [Image 4] Reference xlsform: Calculation.xlsx (9.1 KB) Have a great day!