I created a questionnaire to calculate household income specified to each household member who generate income through employment and other form of income generation. I have no idea how to calculate. I am not able to upload my xls form. How can I post my questionnaire for reference?a5HddwojcxxJYBWpEJDjnJ.xlsx (7.4 KB)
@Kal_Lam this form was made through form builder. Thank you for the references, it helps to my current and future projects better representation. But my problem is, I don’t know the formula to calculate the values. Does “If” command will applicable?
You don’t need to use an if-statement unless you really need to use them. This will help you be specific with what you wish to capture from the repeat group. If you don’t want to be specific you could simply avoid using it.
In my case, I want to sum all of the values that will be gather during the interview. For example, if household head and spouse were employed then their son and daughter were not employed but they have other source of income. Or the other way around.
Have you gone through the workarounds that I shared? It has all the reference xlsform that you should require for your issue. Try uploading them to your account and make some dummy entries. You will then understand how the same works.
@Kal_Lam my concern is not solved by the reference xlsform that you have shared, but it can be my reference for other projects. My concern is to sum the value of income earned/receive by household member. Should I use ‘sum’ or ‘+’ to add the values?. I am new user of Kobo