# Get the average of selected sub-fields in an Input Table field

• Brother2Brother
Asked on July 04, 2017 at 04:33 PM

Hi, I am having difficulty with the form calculation for a satisfaction survey where V. Satisfied=4, Satisfied=3, Neutral=0, Dissatisfied=2 and V. Dissatisfied=1. Also, what would be the best way to display this data (i.e., pie, chart, etc) I'd like to see the number of responses for each question.

This is a re-post of a comment on Form Calculation - Math Function Reference

• BDAVID
Answered on July 04, 2017 at 06:01 PM

You simply need to create a Visual Report: https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions

For the calculation, you need to assign the values to each option, please check this guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

Then perform the calculations: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

Let us know if you need more help.

• Brother2Brother
Answered on July 09, 2017 at 09:37 AM

Hi BDAVID,

I've added the calculation block to my form but it is not adding up correctly.  Not sure what I'm doing incorrectly.  Also it shows the person who completes the form the calculations as well.  Is it supposed to do that?  I want the report to show me the number of satisfied for all the respondents, the number of very satisfied, etc.  Will it do that or do I have to download all the calculations and add them manually?

Very Satisfied=5, Satisfied=4,  Neutral=3, Dissatisfied=2 and Very Dissatisfied=1

I have 2 rating questionnaires.  I am sharing just 1 with you.  I am also sharing the calculations page as well.

• Mike_G
Answered on July 09, 2017 at 11:19 AM

If I'm understanding your concern correctly, I believe what you need is the instructions in this guide — How-to-Perform-Form-Calculation-in-the-Matrix-Field

I see that you have already set calculation values for each sub-fields in the Input Table (Matrix field).

However, as for getting the average, here's what you can do:

Step 1 — add the sub-fields of the Input Table in the calculation.

Step 2 — Move the cursor the at the beginning and add the avg () math function.

Step 3 — Move the closing round bracket of the avg () after the last sub-field of the Input Table.

Step 4 — Separate each sub-field with a comma and save the calculation widget.

Note: Commas are typed manually.

Outcome:

I hope this helps. If you have other questions or concerns, please feel free to contact us again anytime.