How Do I Calculate the Percentage of Checkboxes Completed in a Field?

  • Fifty3Degrees
    Asked on November 9, 2015 at 12:23 PM
  • abajan Jotform Support
    Replied on November 9, 2015 at 3:01 PM

    Thanks for asking. This can be achieved as follows:

    1. Add a Form Calculation widget to the form (see this guide)

    2. In the widget's wizard, click the More Math Functions button:

    How Do I Calculate the Percentage of Checkboxes Completed in a Field? Image 1 Screenshot 50


    3.
    Scroll down to the Other Functions section and click count()

    How Do I Calculate the Percentage of Checkboxes Completed in a Field? Image 2 Screenshot 61


    4.
    Click the Add Field button

    How Do I Calculate the Percentage of Checkboxes Completed in a Field? Image 3 Screenshot 72

    5. Click the tag for the checkbox field to insert it between the parentheses of the count() function

    6. Add *10 to the end of the expression, so that it becomes:

    How Do I Calculate the Percentage of Checkboxes Completed in a Field? Image 4 Screenshot 83

    That's what I did in this demo. Feel free to clone and examine it.

    If you need further help with this, please inform us.

    Thanks

  • abajan Jotform Support
    Replied on November 9, 2015 at 3:14 PM

    Hang on! That expression is incorrect. Let me get back to you shortly.

  • abajan Jotform Support
    Replied on November 9, 2015 at 3:28 PM

    Okay, my apologies. The expression should actually be

    How Do I Calculate the Percentage of Checkboxes Completed in a Field? Image 1 Screenshot 20

    So you would have to manually count the number of checkboxes in the field and substitute it for the 10 in the screenshot. I've updated the expression in the demo.