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

    Average calculation on form

    Asked by Annie Kibler on July 01, 2016 at 11:49 AM

    So with your help, I've successfully done the calculation for my form. BUT, now the client would like to have the AVERAGE calculated too.  I tried to do it on my own - but am hoping you can point me to a thread for that?  

     

    Thank you SO much!!

    calculate average
  • Profile Image
    JotForm Support

    Answered by Mike on July 01, 2016 at 01:22 PM

    Could you please provide a link to the form in question?

    Please also explain what kind of average do you need to calculate.

  • Profile Image

    Answered by anniekibler on July 02, 2016 at 01:28 AM

    Sorry!  Here it is: https://form.jotform.com/61806118379158

    I was hoping to have an Average calculation of all the selected answers.  So I'm sure I have to keep the calculation, but need the average of those answers.  Does that make sense? Thanks!!

  • Profile Image
    JotForm Support

    Answered by Boris on July 02, 2016 at 07:07 AM

    From what I see on that form, Annie, you essentially have 9 required questions. Answers on each of the 9 questions can have a value of either 1, 2, or 3.

    To calculate the average, we simply need to sum the values of all 9 questions, and then divide them by 9.

    I see that your calculation for the average is already set up correctly:

    Your form is set to display result without any decimal places. If you want it to display decimal spaces as well, such as 1.33 or 1.44, please simply click on the "Show Advanced Options", and set the decimal spaces entry to the number you'd like:

    The above method is enough to calculate the average, though I'd like to add that we also have dedicated mathematical functions as well:

    https://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference

    Among the mathematical functions, we have functions for calculating the average. In case of your form, however, the above setup you already have on your form is enough.

    Please let us know should you need any further assistance, we'll be happy to help.