4 Replies Latest reply on May 2, 2015 9:47 AM by Chris Hembel

    Calculating in a form

    Chris Hembel Level 1

      I am once again trying to get this form to work the way that I want it to. The link to the form is here:

       

      Dropbox - HAR-080-ICCAEPRegFormFields.pdf

       

      I need the US Total Paid by Check or MO Field to calculate the sum of the column if there are any entries in the column but remain empty if there is no sum needed. It is not calculating sums of the fields. I can't even get it to sum the columns much less write the "if" statement to make it empty. It seems like it is not converting the loop to numbers to get the sum and is just concatenating the digits. I can't figure out where the + should go to convert the text to numbers.