The avg() function is not working

  • gradelink
    Asked on July 17, 2017 at 2: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.)

    Jotform Thread 1201149 Screenshot
  • Support_Management Jotform Support
    Replied on July 17, 2017 at 2: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).

    The avg() function is not working Image 1 Screenshot 30

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

    The avg() function is not working Image 2 Screenshot 41