Enrollment Sum

[mumtaz4uali]

Kindly support me I am working on an education project, so we will collect data from different classes. what calculation formula should I use. For more details screenshot is attached

[Kal_Lam]

@mumtaz4uali, these post discussed previously should help you solve your issue:

Calculate with Matrix Questions

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!

This one too:

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!

This one too should be helpful:

How to calculate and add column in kobo

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)