Calculate number of person aged between 7 and 15 years old

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

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:

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…

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.

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

Thank you!

1 Like