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,

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:**

**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: How do we design a form with matrix question type where we calculate the totals in column?