The avg() function is not working

  • Profile Image
    gradelink
    Asked 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.)

  • Profile Image
    Jim_R
    Answered 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: