XLSForm: How to display a score based on a yes/no question

  1. Put 0 as name value for No and 1 for Yes
  2. Add a calculate row to calculate the total of “yes”
  3. Add another calculate row to generate the scoring
    if (${total_score} = 4, ‘100%’, if (${total_score} = 3, ‘75%’, if (${total_score} = 2, ‘50%’, if (${total_score} = 1, ‘25%’, ‘NA’)))
  4. Display the result in a note.

scoringxls-eng

 

 

 

scoring-choicexls-eng

 

 

 

 

 

 

 

 

Category: Create a New Questionnaire, Questionnaires, Create Questionnaires, Questionnaire > Questionnaire

← Return to search results