How to add the average answer of all of the questions in my form.

Hello,

I am trying to find the average answer of all of the questions in my form. I have added the Form Calculation widget with the average function but it is only giving me the added total. I have tried both the + and , between each question in the function but that did not work either.

Here is the link to my form

https://form.jotform.com/252365493936064

And the link to be a collaborator

https://www.jotform.com/build/252365493936064?iak=8ca59ab798a084f4b8448690b149f935-7e918da8f1cdc483

Thank you,

Renee

Hi Renee, I understand you're looking to calculate the average of the answers in your form. I suggest checking out the guide for using advanced formulas in Jotform Tables. You can find more information via the button below. Let me know if you need anything else!
Show Guide

Hi Renee,

Thanks for reaching out to Jotform Support. To achieve what you want, you'd have to have two Form Calculation widget in your form. The first widget should calculate the total of the questions, then the 2nd will calculate the average. Here's how:

1. In Form Builder, click on the Add Element from the upper-left corner.

2. In Form Elements, go to Widgets tab.

3. Search and select the Form Calculation widget.

4. On the 1st Form Calculation widget, click its Gear icon to open its properties.

5. In Form Calculation Properties, go to Advanced tab.

6. Key in the Field Label, and then toggle the Hide Field to On.

7. Click on its Wand icon to open its Settings.

8. In its Settings, click on the Add Field from the Calculator.

9. Select the 1st question Field from the form, and then click on the + symbol to calculate its total.

10. On the Last Field, do not add the + symbol, then click on Save.

After setting up the 1st Calculation, add another Form Calculation widget. This widget will calculate the Total's average. Here's how:

11. On the 2nd Calculation widget, click on its Wand icon.

12. In its Settings, click on the f{x} Symbol in the Calculator.

13. Search and select f{x}avg.

14. Next, click on the Add Field to add the Total Field in the Calculation.

15. Then add the Divide symbol / and the Number Figure outside the Parenthesis.

16. After dividing the Total on 6, click on the Save button at the bottom.

See the screencast below to see my results:

Let us know if you have any other questions.