Could you help me build a calculation to add up and classify selected questions?
hi @barata_clicia1 ,
Unfortunately your question is not clear enough, can you elaborate more so we can try to help?
I wanna create a group of questions each has:
Seven questions each type are “select one”, each answer has an assigned value;
After each single-selection question has been answered, I would add up the values assigned to each answer.
After adding up, I would show the result of the ranking on the form, which will be:
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
@barata_clicia1 , these posts discussed previously should help you solve your issue:
@horeb_nahor , maybe you could do it as oultined in the image shared below:
[Image 1]
[Image 3]
[Image 4]
Auto Select.xls (29.5 KB)
And this one too …
@bikky2044 , you should be able to do it as outlined in the image shared below:
[image]
[image]
[image]
[image]
[image]
PreFill.xlsx (13.5 KB)
This one too …
@Ghassan_wilson , maybe you could do it as outlined in the image shared below:
[Image 1]
[Image 3]
[Image 4]
[Image 5]
[Image 6]
[Image 7]
Reference xlsform:
Livelihood.xlsx (11.5 KB)
And this too …
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 …
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:
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.
Can you share your XLS form with us?
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 belowjob_plan.xlsx (11.1 KB)
