If statement to score 'select many' responses

User Support Form Building
, , ,
1

Hi,

I am trying to calculate the score of a select many question. There are four responses and, in this case, the user needs to select three of them correctly to get a mark. I have tried using:

if(selected(${Work},‘a’) and selected(${Work},‘b’) and selected(${Work},‘d’),1,0)

but if they select all answers (a,b,c,d) they are awarded a mark. Any advice on how to only include the correct answers would be appreciated.

Thanks!

2

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

3

Hi @Kal_Lam,

Thanks for the welcome and the quick response. I think I have previously looked at that thread and noted it didn’t quite do what I needed. My understanding from the example is each question has a score which is then summed, whereas I need the calculation to only give one point if they selected three correct answers, any other combination would result in 0 points.

4

OK, could you kindly share with us your condition (possibly with a short dummy question and a response) so that we could see how it looks like.

5

If responses a, b, and c are selected then user gets 1 point, otherwise user gets 0 points.

Dummy Q (select many) - What themes do you work with? Select all that apply.

a) Maternal Health
b) Newborn Health
c) Construction
d) m-Health

1 Like
6

Should all a, b and c all get selected or should a, b or c (any of them get selected)?

7

Maybe the image outlined below should solve your issue:

In the survey tab of your xlsform:

Image 1
Image 11317×209 9.44 KB

In the choices tab of your xlsform:

Image 2

Data entry screen as seen in Enketo: condition for Q1 met

Image 3
Image 3676×753 19.2 KB

Data entry screen as seen in Enketo: condition for Q1 & Q2 met

Image 4
Image 4675×753 20 KB

Data entry screen as seen in Enketo: condition for Q2 met

Image 5
Image 5674×751 19.1 KB

Data entry screen as seen in Enketo: condition for neither Q1 nor Q2 met

Image 6
Image 6675×752 20.3 KB

Reference xlsform:

Calculation.xlsx (11.6 KB)

1 Like
8

Ah great, thank you so much. So I was just missing the not(selected) part of the statement - it seems so obvious now. Thanks again - have a great weekend!

2 Likes