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.


  • Profile Image

    I am not getting a total unless all fields have a value.

    Asked by pennistritter on January 31, 2014 at 11:10 PM

    I am not getting a total unless all fields have a value. What if one field is left blank? How do I get the total to show then?



    This is a re-post of a comment on How to Perform Form Calculation Using a Widget

    all then
  • Profile Image
    JotForm Support

    Answered by liyam on February 01, 2014 at 04:24 AM

    Hello pennistritter,

    This is because the computation will not perform the exact formula unless all fields involved are filled or has a value.  As a result, all fields will be required to be filled up before you can get a total.  

    You can however set your form's fields to be required so that all fields will be filled up properly. Simply look for the Required option on the tool bar of your form builder.

    Please let us know if you have further questions.

    Thanks.

  • Profile Image

    Answered by shahabeddini on June 04, 2015 at 04:52 AM

    I need to calculate the average of some fields value.  Some of these fields may be left blank.

    In normal situation, the value of blanked fields are 0. 

    How can I exclude blanked fields  from calculation?

  • Profile Image

    Answered by shahabeddini on June 04, 2015 at 05:07 AM

    Next Question:

    Can I do calculation with dynamic fields, like what we use in Configurable List widget?

     
  • Profile Image
    JotForm Support

    Answered by Boris on June 04, 2015 at 05:15 AM

    shahabeddini, please post your questions in new threads instead, so that we may avoid confusion, as well as making sure that the person who opened this thread doesn't get emails unrelated to their issue.

    Your question about calculating average while excluding some fields has been moved here:

    http://www.jotform.com/answers/581840

    Your question about calculations in dynamic fields, such as in Configurable List widget, has been moved here:

    http://www.jotform.com/answers/581842

    Thank you.