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

  • Profile Image
    pennistritter
    Asked 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

  • Profile Image
    liyam
    Answered 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
    shahabeddini
    Answered 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
    shahabeddini
    Answered 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
    Boris
    Answered 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.