Calculate number of person aged between 7 and 15 years old

[camillecbx]

Hello Kobo experts,

I try to figure out how to calculate the number of person aged from 7 to 15 years old, based on a repeat group registering all family members. Please find a screen shot below:

How could I fix the yellow field?

Thank you very much!

Camille

[Kal_Lam]

Hi @camillecbx,

Welcome to the community! I am sharing with you a discussion that is similar to your current issue and assume that it should solve your problem:

Calculating inside a loop

Hi All, Am doing a project which requires to calculate number of caregivers in a home(this is a loop). Based on the number of children under each care givers I will need to do another loop for the children under each caregiver. Is it possible to have 2 separate loops but the total sum in the 1st loop acts as the control for the 2nd loop and I will also need to pull in the names of the care givers into the 2nd loop so as to know how which child belongs to which caregiver. After establishing t…

[camillecbx]

Thank you very much for your prompt answer.

If I understand well the example, could the solution be this ?

I am not sure about the way I wrote the condition IF…

[Kal_Lam]

Hi @camillecbx,

You could use the if(${age} >= 7 and ${age} <= 15, 1, 0 ) to get the count of children in between 7 to 15 years.

[camillecbx]

It works, thank you so so much! Indeed, the condition wasn’t correct.

Thank you!