- AneeshRylandsAsked on July 30, 2015 at 06:44 AM
I need to calculate an average result.
i want to sum the contents of about ten fields and the divide that result by the number of those fields that is actually filled in.
- JotForm SupportabajanAnswered on July 30, 2015 at 09:34 AM
Here's a jotform illustrating the desired functionality. This example uses Number fields
which by their very nature restrict users to entering just numbers but other field types like regular text boxes, drop downs and radio buttons can also be used.
(The Add Field button is used to insert the tag for the field.)
If you need more help with this, please let us know.
- JotForm SupportabajanAnswered on July 30, 2015 at 10:13 AM
I should add that it's possible to assign numeric values to non-numeric options of drop down and radio button fields by going into their properties:
and entering the values in the Calculation Values field. By default, drop downs have a blank selection for which a value, even if it's 0, must be included: