-
terynlongAsked on July 1, 2022 at 4:57 PM
I am needing to create an average based only on the boxes with input, not the whole table. How can I do that?
Page URL: https://form.jotform.com/221635697659068 -
Fahad JotForm SupportReplied on July 1, 2022 at 6:57 PM
Hi Teryn,
Thanks for reaching out to Jotform Support. You can easily calculate the average of the filled fields in the input table. We have a method avgNoZero in our Match functions in form calculation field.
In your average calculation field go to widget settings and add the average method.
After that in the function add the input table fields with comma separated. Please click the comma in the calculate section in order to change to number type, and not string. The comma should have a black background.
After that test in your form and the average field will calculate the average of only filled fields. I have created a demo form please check this form: 221817060712044
You can clone it into your account and see the calculations. Please check the guide for cloning form to your account.
Give it a try and let us know how it goes.