3 Replies Latest reply: Jun 25, 2015 7:58 AM by jb@sharp _ RSS

    Adding a set of fields where some may be blank

    jb@sharp _

      I am trying to create a calculated field that adds several other fields together where the field contents are sometimes blank.  When I do this my result is null (or 0 or whatever the default value is for a blank field) instead of the total of the other fields.  Does anyone know of a workaround for this?

       

      Thanks,
      Jeff