How to calculate and add column in kobo

Dear Kal_lam,
Could you please help how to create the form i.e

Looking forward to your kind support.


Dear Palash,

You can create calculate questions with basic sum formulas for all answers needed as shown in your table. Something like ${q11}+${q12}+${q13}+${q14}+${q15} … You can show each result using separate note questions.

The original questions should be obligatory (have a response), as questions without a response make the + operator fail (produce the code NaN not a number). You could solve that by making first if( , ,) calculations of each answer where the number zero is assigned if there is no answer.


1 Like

Maybe you could do it as outlined in the image below:

In the survey tab of your xlsform:

In the choices tab of your xlsform:
Image 2

In the settings tab of your xlsform:
Image 3

Data entry screen as seen in Enketo:

Reference xlsform:
Matrix Questions (Calculation).xls (46 KB)

1 Like