Calculate yes option in Matrix Questions

[Kal_Lam]

Welcome to the community, @Fayed! Yes, but it’s only possible through the xlsform. Maybe these post discussed previously should help you visualize adding calculations within your matrix question:

Workaround 1:

How to calculate and add column in kobo

Maybe you could do it as outlined in the image below: In the survey tab of your xlsform: [Image 1] 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: [Image 4] Reference xlsform: Matrix Questions (Calculation).xls (46 KB)

Workaround 2:

How to collect information from different organization in a matrix question which has an auto calculation at the last column?

Hi @PALASH9698, You could do it as outlined in the image below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Matrix Auto Calculation in Column (2020 09 09).xlsx (13.7 KB) Have a great day!

Workaround 3:

How do we design a form with matrix question type where we calculate the totals in column?

Hi @exaud1993, You could design a survey form with a matrix question type where you calculate the last column as shown in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the setting tab of your xlsform: [Image 3] Data entry screen as seen in Enketo: [Image 4] Reference xlsform: Matrix Questions (Calculation).xls (44.5 KB) Have a great day!

Workaround 4:

Calculate with Matrix Questions

Hi @fmi, You could use calculate within the matrix question type as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: The values within the red highlighted box is an auto calculated value. [Image 4] Reference xlsform: Matrix Questions (Calculation).xls (46.5 KB) Have a great day!