Calculating a weighted score using the if statement in KoBoToolbox

Dear Kal_Lam,
Good Morning!
Thank you very much for your kind support. As per your instruction, I have developed a form which form calculating the score well…
But in one portion i cant manage the calculation.


in Washington Group Short Set Questions if anyone select Yes, some difficulty or yes a lot of difficulties question (1-6 any of of the question only 5 point for selection )
in the section a) no:2- Persons with disabilities… only add 5 points add.

Attached find my xls formpalash.xlsx (16.7 KB)

looking forward to your kind response in this regard.
Best Regards
Palash.

Hi @PALASH9698,

As far as i understood you, if Yes, some difficulty or Yes, a lot of difficulty is selected for a question say Q1 (5 score is added) similarly if the same is selected in Q2 (another 5 score is added) … and finally you add Q1 to Q6? Did i get that correct?

Meanwhile i did not understand this that you have mentioned in the post:

Have a great day!

Dear Kal_Lam,
Q1-Q6 (Only 5 score is added)
if anyone Q1-Q6= Yes, some difficulty, a lot of difficulty score will be =5
or if anyone Select only one question Yes, some difficulty,a lot of difficulty then also score will be =5
else anybody Q1-Q6 select No, no difficulty,Cannot do it at all then score =0

Best Regards
Palash

Hi @PALASH9698,

You could do the same as outlined in the image below:

In the survey tab of your xlsform:

In the choices tab of your xlsform:
Image 2

Data entry screen as seen in Enketo: When none of the conditions satisfy

Data entry screen as seen in Enketo: When one or more conditions satisfy

Reference xlsform:
Disability Weighted Score.xlsx (11.8 KB)

Have a great day!

1 Like

Hello @PALASH9698,
sorry, but are you sure?
I would believe, it should be like
if( (${SeeDisability} > 2 or ${HearDisability} > 2 or ${WalkDisability} > 2 or ${RememDisability} > 2 or ${SelfcareDisability} > 2 or ${CommuDisability} > 2), 'Yes", ‘Np’).

See here for UN example: http://www.washingtongroup-disability.com/wp-content/uploads/2016/12/WG-Document-5A-Analytic-Guidelines-for-the-Washington-Group-Short-Set-SPSS.pdf
Kind regards