Can you have a calculated field if some of the fields are blank?

  • Profile Image
    Asked on March 02, 2014 at 01:14 PM

    I want a "grand total" at the end of my form.  However, it will not calculate if some of the fields are left blank. Is there anyway to "assume zero" in a blank field? This final calculation will include fields on pages that they may not go to (depending on other options); so I can't "require field". Is there any way to do this?

  • Profile Image
    Answered on March 02, 2014 at 02:45 PM

    Hi, I see what you mean, the calculation widget would not calculate if the fields are left in blank:

    At this moment the best thing to do is to set the fields as "required", I have submitted a request to our second level to have this implemented, however we can not assure you if this will be implemented or how long it will take. You will be notified via this thread when this happens.

  • Profile Image
    Answered on March 02, 2014 at 03:06 PM

    Another work around I have used - make the field 'required' and set the default value to 0. You can also make one of the choices = 0 , or you can disguise it by using a string like "CH00SE an option" (using zeroes not letter O) as your default value.