Fayed
February 25, 2021, 1:33pm
1
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,
Kal_Lam
February 25, 2021, 1:39pm
2
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:
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)
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!
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!
