-
AneeshRylandsAsked on July 30, 2015 at 6: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.
-
abajan Jotform SupportReplied on July 30, 2015 at 9: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 demo also has a Form Calculation widget. If you clone the form and examine the work area of the widget, you'll see the following expression:
(The Add Field button is used to insert the tag for the field.)
If you need more help with this, please let us know.
Cheers
-
abajan Jotform SupportReplied 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:
Thanks