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

exaud1993 · May 22, 2020, 11:17am

@Kal_Lam how could I design a form ( matrix one) which have a calculation in the last column instead of last row ie calculation to be row wise

Kal_Lam · May 22, 2020, 2:49pm

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:

In the choices tab of your xlsform:

In the setting tab of your xlsform:

Data entry screen as seen in Enketo:

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

Have a great day!

exaud1993 · May 22, 2020, 4:57pm

thanks for your support @Kal_Lam

exaud1993 · May 24, 2020, 2:49pm

Hi @Kal_Lam

I designed form using grid technique -w2 but after previewed and deployed in enketo it appearance is not as planned instead of just two columns it showup with four columns as shown in image hereby

but my plan is to appear like this one

what is the problem ? and how can i resolve it?

Kal_Lam · May 24, 2020, 2:54pm

Hi @exaud1993,

To better understand on Grid Theme, please have a look at the Enketo blog here. It should guide you with w1, w2….w10 markup used in the ‘appearance’ column.

Have a great day!

exaud1993 · May 24, 2020, 3:32pm

@Kal_Lam

it work thank you

the issue is previous I used w2 instead of w3

thank you

myriamdagher1 · August 10, 2023, 4:15pm

Hello @Kal_Lam , how can I adjust the example that you sent with the following changes:

Have columns of different widths
-Freeze the first row so that when the person scrolls down the survey they are able to keep seeing the instructions?

Can you help in these?