Calculate with Matrix Questions

Hi Kobo Community!

Is there a possibility of using calculate function with matrix questions? I have tried using the label for each row/column of the matrix but it is not recognised when I try use the preview function.

Many thanks,

1 Like

Hello,
I think you need to use variable names, not the labels.
Best regards

1 Like

Hi @fmi,

You could use calculate within the matrix question type as outlined in the image below:

In the survey tab of your xlsform:

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.

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

Have a great day!

1 Like

A post was split to a new topic: My results appear in a different sheet. Why?

A post was split to a new topic: How do we design a form with matrix question type where we calculate the totals in column?