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

  • adeptclass
    Asked on September 5, 2018 at 5: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.

  • jonathan
    Replied on September 5, 2018 at 6: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)

    Is there a way to get the average sore of calculated submissions? Image 1 Screenshot 50

    Here's an example calculation on my cloned form:

    Is there a way to get the average sore of calculated submissions? Image 2 Screenshot 61

    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)

    Is there a way to get the average sore of calculated submissions? Image 3 Screenshot 72

    Here's an example calculation:

    Is there a way to get the average sore of calculated submissions? Image 4 Screenshot 83

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


    ---