Calculate a column total for a matrix question

[astridcastro]

Hi, I would like to create a table whit a column “Total” where the result will be calculated using the values of columns “Periodo 1 + Período 2, …, +Periodo 12”. And, I have a problem with the visualization of the table in the form because it’s not shown as a table.

[Kal_Lam]

Hi @astridcastro,

Kindly please be informed that calculating a column total for a matrix question at the moment is not possible with the form builder UI. However you could do the same through the xlsform as outlined in the post discussed previously:

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!

Have a great day!