Avoiding Zero Household Occupancy

[bkgwadi]

CFARegistration_SingularResidency.xlsx (19.0 KB)
I need assistance just to identify where I am going wrong. The template refuses to proceed where a household with one occupier is captured. For example if there is only 1 male who is 20 years old. Please help!

[stephanealoo]

Hi @bkgwadi
Consider adding a calculate question in between the two questions and reference the calculate question in the NoOfFemales as shown in highlights below

Stephane

[bkgwadi]

Thanks @stephanealoo Is there a way my Excel worksheet can be edited, am a basic user of XLS Forms and I am digging deep in a no solution kind of thing

[Kal_Lam]

@bkgwadi, you could do it as outlined in the post discussed previously:

How to extract required information from a repeat group to a note question?

OK, if this is your requirement, you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Repeat Group.xlsx (11.6 KB)

This one too should be helpful for you …

Income calculation inside a repeat group

@EWPD1, you could do the same as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Repeat Group.xlsx (12.5 KB)

[bkgwadi]

CFARegistration_SingularResidency.xlsx (19.1 KB)

Have tried that to no avail, more error messages.

[bkgwadi]

Prevent_Zero_HouseholdMembers.xlsx (16.5 KB)
Hie @Kal_Lam I replicated the example of preventing a zero household situation originally it was with two variables totmales and totfemales. But I am now failing to do that for the expanded variables ie I now have 4 from two. How can I still prevent a user punching in zero’s in all the four variables that measure number of people in a household?

[Kal_Lam]

@bkgwadi, in this case, you could follow the workaround discussed previously:

How to constraint a sum so that the inputs do not exceed the total entered previously?

Welcome to the community, @theo27! This final line added highlighted in yellow should help you achieve what you intend to: [image] Reference XLSForm: Constraint Example.xlsx (10.9 KB)

[bkgwadi]

This works well but say on Q1, you iput 10 and on Q2, you also input 10 and the rest being zeros, it becomes an error.

[bkgwadi]

It works well without the relevance conditions!