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

    The avg() function is not working

    Asked by gradelink on July 17, 2017 at 02:37 PM

    On our survey the individual fields are calculating correctly, but the Average field doesn't seem to work. Not sure what I'm missing here. (Note, formula currently only includes two fields for simplicity.)

    Page URL:
    https://form.jotformpro.com/71925985679984

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Jim_R on July 17, 2017 at 02:54 PM

    The comma in between the 2 fields that you're averaging is set as a string (text). To fix this, just click the comma so the background changes from brown to black (string to number).

    For future reference, here's the color coding legend: