What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How Do I Calculate the Average (Mean) Result of Any Number of Inputs?

    Asked by AneeshRylands on July 30, 2015 at 06:44 AM

    I need to calculate an average result. 

    i want to sum the contents of about ten fields and the divide that result by the number of those fields that is actually filled in. 

     

    form calculator divide calculate average display average form calculation calculation values add display the mean
  • Profile Image
    JotForm Support

    Answered by abajan on July 30, 2015 at 09:34 AM

    Here's a jotform illustrating the desired functionality. This example uses Number fields

    which by their very nature restrict users to entering just numbers but other field types like regular text boxes, drop downs and radio buttons can also be used.

    The demo also has a Form Calculation widget. If you clone the form and examine the work area of the widget, you'll see the following expression:

    (The Add Field button is used to insert the tag for the field.)

    If you need more help with this, please let us know.

    Cheers

  • Profile Image
    JotForm Support

    Answered by abajan on July 30, 2015 at 10:13 AM

    I should add that it's possible to assign numeric values to non-numeric options of drop down and radio button fields by going into their properties:

    and entering the values in the Calculation Values field. By default, drop downs have a blank selection for which a value, even if it's 0, must be included:


    Thanks