What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Total average using Average Function is incorrectAsked by simonebrennan on June 09, 2014 at 08:09 PM
Form number http://www.jotform.co/form/41387056938869
I notice that the total average (on the last page) is usually incorrect when calculating the averages. Is this due to rounding when making the calculations? I tried increasing from 2 to 3 decimal places, but still getting an error.
Also sometimes the other averages are a bit off too, usually if there is a great wide distribution in the answers (e.g. not all 4)
I was checking and the average functions, and they seem to be workgin fine:
Could you let us know what are the values you are entering, and what would be the average result?
Hi, here is an example of my issue. Have I made an error somewhere?
In the Calculation Wizard for the Total Average field, please remove the last comma (indicated below) and let us know if it helps:
Thanks for your help. I took out the additional comma, however I am still getting the issue.
It seems like the the decimal values aren't being included in the calculation.
With that said, I have raised a ticket for this bug.
You will be notified, via this thread, if and when it gets fixed.
Thank you for your patience.