Income calculation inside a repeat group

[Kal_Lam]

@EWPD1, we have some workarounds (on how to calculate a sum from within a repeat group) which should be helpful for you:

Display of the name of the eligible individual in the next repeat group question

You could design your xlsform as shown in the image 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: Household (Count) Repeat Example.xlsx (28.9 KB)

Another one:

Activating an individual questionnaire only if there are eligible respondents from within a household roster

In this case, you could simply skip a group if a condition is met as shown in the image 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: when a condition is not met [Image 3] Data entry screen as seen in Enketo: when a condition is met [Image 4] Reference xlsform: Selecting an Eligible Respondent.xlsx (11.3 KB)

And this one:

Fill in automatically

Maybe you could try it out as outlined in the image below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: How to auto select_1.xlsx (10.9 KB)

Here too:

Calculating inside a loop

Hi @PaulN, See an example on how to calculate inside a repeat group: In the survey sheet: [image] In the choices sheet: [image]

Last but not the least:

How to restrict the data with only one Head of Household from within a household survey?

Hi @Mumlaqs, Please tryout as shown in the image below to restrict your data with only 1 (or with at least 1) head of the household from within your household roster survey form. In the survey tab of the xlsform: [Image%201] In the choices tab of the xlsform: [Image%202] Reference xlsform: Head of the HH.xls (29 KB) GOOD DAY!