Hi Community; I was to use calculate function in two variables/question.
Question 1: Gender of respondent (Choice 1-female, 2- Male)
Question 2: Age of the respondent (this is integer type)
How do i put a calculate so that it returns 1 if gender is female between age 15-49 and 0 (Zero if not)?
Welcome back to the community, @smacharia! You could do this as outlined in the image shared below:
In the survey tab of your XLSForm:
In the choices tab of your XLSForm:
Data entry screen as seen in Enketo:
Data entry screen as seen in Enketo:
Data entry screen as seen in Enketo:
Sample XLSForm:
Calculate Score.xlsx (10.5 KB)
Thanks alot @Kal_Lam . This is Excellent!
1 Like
