31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

Calculation to sum checkbox responses

I have a patient questionnaire that requires you to select all the words from a grouping of words that best describes your pain. You can select as many words that apply to your pain from each group. As a result the response type is checkbox for each grouping of words. For example I’ve listed two word grouping below.

I want to be able to get a total of the number of words selected over multiple groupings of words. For example if the patient selected blistering and burning from group one and shocking and shooting from group two. I want a calculation field to return the score of 66.6% (4/6*100). Is it possible to count the number of words selected when the response type is checkbox?

Thank you


  • haenselhaensel Posts: 602 ✭✭✭

    I'm not aware of a simple solution for this.
    The easiest way is to make a separate radio field for all the answers and use yes (1) and no (0) as options. You can add up all the values as needed.
    Another option is to use rules (6.7, 6.7.5) or JavaScript (12.2.2) to calculate the value but this seems to be a lot of writing to me.


    6.7 Rule Expressions
    6.7.5 The Contains Operator
    12.2.2 The calculation Script
Sign In or Register to comment.