Is there a way to get the average sore of calculated submissions?

  • Profile Image
    adeptclass
    Asked on September 05, 2018 at 05:36 PM

    I want to know how can we auto calculate the average of certain scores that were submitted through the form?

    Please let me know if this is possible. Thank you in advance.

  • Profile Image
    jonathan
    Answered on September 05, 2018 at 06:06 PM

    Avg() calculate function is possible.

    Please check the user guide: https://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference

    ---

    1. avg()

    Returns the average value of the list of numeric values. 

    Function usage: avg(value 1, value 2, value 3)

    Here's an example calculation on my cloned form:

    You can find the example avg() function here: https://www.jotform.com/70991655420964

    2. avgNoZero()

    Calculate average value while excluding empty fields. 

    Function usage: avgNoZero(value 1, value 2, value 3)

    Here's an example calculation:

    You can test this function on my cloned form here: https://www.jotform.com/70991655420964. Look for the avgNoZero() heading


    ---