Form Calculation Widget: Unable to calculate correctly

  • Owen Allen
    Asked on September 6, 2022 at 10:59 PM

    I am trying to calculate the average of 6 numbers. The youtube videos don't quite give me enough instruction to make the calculations work. So if I add 6 number forms and a total form then I can add them okay but the averaging function or manual syntax for division doesn't work.

    Page URL: https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget/
  • Rahul JotForm Support
    Replied on September 7, 2022 at 12:48 AM

    Hi Allen,

    Thanks for reaching out to Jotform Support. I'll need a bit of time to look into this and will get back to you as soon as I can. Thanks for your patience and understanding.

  • Rahul JotForm Support
    Replied on September 7, 2022 at 1:02 AM

    Hi Allen,

    Thanks for patiently waiting. To do correct calculation, try separating number with brackets ( ). See the screencast below showing a demo of calculation of the average of the total of three numbers:

    1662526624 631824a0470f6 Average Screenshot 10

    Additionally, you could clone my test form (https://form.jotform.com/222490442062044) to see the settings and the formula used in the Form calculation widget and to do more test on it.

    Let us know if you have any other questions.

  • OwenAllen
    Replied on September 11, 2022 at 4:02 AM

    Finally gotten around to following your instructions. It works correctly for me. Thank you.