Reverse score calculations (composite index)

Hi there.

I have an 18 question tool with a 5 point likert response scale (1 = Strongly disagree 2 = Disagree 3 = Undecided 4 = Agree 5 = Strongly agree).

I would like to calculate a total score for each respondent but have 8 questions where these need to be reverse scored. So items 1, 2, 5, 6, 7, 8, 17, and 18 should be reverse scored as follows: (1=5) (2=4) (3=3) (4=2) (5=1).

I have tried this for the reverse scored questions
if(${Q1}=‘Strongly disagree’,5,0)+if(${Q1}=‘Disagree’,4,0)+if(${Q1}=‘Undecided’,3,0)+if(${Q1}=‘Agree’,2,0)+if(${Q1}=‘Strongly agree’,1,0)

And this for the others
if(${Q3}=‘Strongly disagree’,1,0)+if(${Q1}=‘Disagree’,2,0)+if(${Q1}=‘Undecided’,3,0)+if(${Q1}=‘Agree’,4,0)+if(${Q1}=‘Strongly agree’,5,0)

But I keep getting an error message that the “parser is broken”

I would appreciate some help with the expressions for the calculation.

Many thanks,


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:

In the choices tab of your xlsform:

Image 2

Data entry screen as seen in Enketo:

Reference xlsform:

Weighted Score Sample.xlsx (11.7 KB)

1 Like

Thank you! That has worked. I just reversed the score calculation for the relevant questions.