The total number of male and female should not exceed the total membership

[Lykah]

My form has Total Membership, total number of male and female. The total number of male and female should not exceed the total membership. And if the total number of male is equal to total number of membership , total number of female should be zero and vice versa. What function should i use?

[Kal_Lam]

Welcome to the community, @Lykah! 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!

[Lykah]

Thank you so much.