How to assign scores for each option in different questions and get a summation at the end of all questions (composite index)

[Kal_Lam]

Welcome to the community, @ochaba! Maybe these post discussed previously should help you solve your issue:

How to build an eligibility criteria from the weight assigned to certain conditions (composite index)

OK, here is the revised one. This should work as you outline: 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: when conditions are not met [Image 2.5] Data entry screen as seen in Enketo: when conditions are not met [Image 3] Data entry screen as seen in Enketo: when conditions are not met [Image 4] Data entry screen as seen in Enketo: when conditions are met [Image 5] Reference xlsform: Eligibility Cr…

This one too …

Calculate based on respondent selection (composite index)

OK, in this case you could do the same as outlined in the image shared 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: Mild [Image 3.1] Data entry screen as seen in Enketo: Mild [Image 3.2] Data entry screen as seen in Enketo: Severe [Image 4.1] Data entry screen as seen in Enketo: Severe [Image 4.2] Data entry screen as seen in Enketo: Very Severe [Image 5] Reference xlsform: Composite Inde…

And this one too …

Calculate using IF Formula with Multiple Expression (composite index/weighted score)

Well if this is your requirement, you could design your survey project using the following if-statement as outlined in the image shared 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: If option 1 is selected, the system gives a score of 3 [Output 1] Data entry screen as seen in Enketo: If option 3 or option 2 is selected with 1, the system gives a score of 3 [Output 2.1] Data entry screen as seen …

Here is another one …

Question Selection and point Calculation (weighted score/simple composite index)

Hi @PALASH9698, You could do this in a simple way 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: [Image 3] Reference xlsform: Weighted Score Sample.xlsx (11.9 KB) Have a great day!

And this one too …

Hide field until 5 or more questions have been answered (composite index)

You could do the same as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsorm: [Image 2] Data entry screen as seen in Enketo: (when the conditions are not met) [Image 3] Data entry screen as seen in Enketo: (when the conditions are met) [Image 4] Reference xlsform: Severity_scale_V2.xlsx (12.6 KB)

And one more …

Assigning a certain value from a question's choice (composite index)

OK, you could do the same as outlined in the image shared below: In the survey tab of your xlsform: [Image 101] In the choices tab of your xlsform: [Image 102] Data entry screen as seen in Enketo: when no entries is made [Image 103] Data entry screen as seen in Enketo: when “Yes” is selected in Q1 [Image 104] Data entry screen as seen in Enketo: when “No” is selected in Q1 [Image 105] Reference xlsform: Weighted Score Sample.xlsx (11.4 KB)

One more …

Reverse score calculations (composite index)

Welcome to the community @ashirley! Maybe you could do the same as outlined in the image as shared below: In the survey tab of your xlsfrom: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Weighted Score Sample.xlsx (11.7 KB)

And one final one …

How to calculate a weighted score (a simple composite index) while collecting data with KoBoToolbox?

Hi @bamaiyi, You could do this following the instructions outlined below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference xlsform: Weighted Score Sample.xlsx (10.2 KB) Have a great day!