Summing and sorting answers

[barata_clicia1]

Could you help me build a calculation to add up and classify selected questions?
Example:
1st I would like to add up a value assigned to each answer of the questions;
2º After the sum, the result would be classified according to 3 types of parameters.
3º Display the result

[osmanburcu]

hi @barata_clicia1,

Unfortunately your question is not clear enough, can you elaborate more so we can try to help?

[barata_clicia1]

I wanna create a group of questions each has:

1. Seven questions each type are “select one”, each answer has an assigned value;
2. After each single-selection question has been answered, I would add up the values assigned to each answer.
3. After adding up, I would show the result of the ranking on the form, which will be:
   a)Basic;
   b)Intermediate;
   c)Advanced; or
   b) Consolidated

[osmanburcu]

Hi, this previous discussion could give you some idea about it, if you are still unable to solve it let us know Getting sum of different variables

[Kal_Lam]

@barata_clicia1, these posts discussed previously should help you solve your issue:

Automatic configuration of a question

@horeb_nahor, maybe you could do it as oultined 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 as seen in Enketo: when the condition is not satisfied [Image 3] Data entry as seen in Enketo: when the condition is satisfied [Image 4] Reference XLSForm: Auto Select.xls (29.5 KB)

And this one too …

How to prefill a select_one question based on the previously selected select_multiple question?

@bikky2044, you should be able to do it as outlined in the image shared below: In the survey tab of your XLSForm: [image] In the choices tab of your XLSform: [image] Data entry screen as seen in Enketo: when nothing is selected in Q1 [image] Data entry screen as seen in Enketo: when any two choices are selected in Q1 [image] Data entry screen as seen in Enketo: when any three choices are selected in Q1 [image] Reference XLSForm: PreFill.xlsx (13.5 KB)

This one too …

How to calculate the income per preson and prefill a select_one question?

@Ghassan_wilson, maybe you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Data entry screen as seen in Enketo: [Image 4] Data entry screen as seen in Enketo: [Image 5] Data entry screen as seen in Enketo: [Image 6] Data entry screen as seen in Enketo: [Image 7] Reference xlsform: Livelihood.xlsx (11.5 KB)

And this too …

Dynamic set a default value for a select_one question type based on another select_one question

Maybe 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: when nothing is selected [Image 3] Data entry screen as seen in Enketo: when Cat A is selected [Image 4] Data entry screen as seen in Enketo: when Cat B is selected [Image 5] Data entry screen as seen in Enketo: when New Cat is selected [Image 6] Reference xlsform: Auto Select.xls (29.5 KB…

This too …

How to auto select a response for the subsequent question basing a response from a previous question?

Hi @Ah_ly, You could do the same as outlined in the image below: In the survey tab of your xlsform: [Image 0.1] In the choices tab of your xlsform: [Image 0.2] Data entry screen seen in Enketo: [Image 0.3] Here Never is automatically selected in Q2 when Never is selected in Q1. Reference xlsform: Auto Select.xls (29.5 KB) Have a great day!

[barata_clicia1]

@barata_clicia1

Consolidated

I try all this options but it’s still not what I need to do, check below if you understand the logic:
Survey

Choices

When I try to add up the values from the selected options, the calculation doesn’t work.

[osmanburcu]

Can you share your XLS form with us?

[barata_clicia1]

job_plan.xlsx (11.0 KB)

[osmanburcu]

Your mistake caused by the signs, if you would to say smaller or equal to something you use “<=” but you used “=<” which is wrong so that your formula was not working. Please find the corrected version below
job_plan.xlsx (11.1 KB)

[barata_clicia1]

THANK YOU SO MUCH!!!

@osmanburcu

Your mistake caused by the signs, if you would to say smaller or equal to something you use “<=” but you used “=<” which is wrong so that your formula was not working. Please find the corrected version below
job_plan.xlsx (11.1 KB)

[Kal_Lam]

@osmanburcu,