2 Replies Latest reply on Nov 23, 2011 8:28 AM by Abby0913

    Trouble performing a simple addition calculation in LiveCycle Designer

    Abby0913

      Hi Everyone, I have browsed the forums and the Internet for a solution to my problem, to no avail. scripts I found in other forums would not work for me. Sorry if I should not be starting a new discussion, but came up short everywhere else. I'm fairly new to JS as well, and brand new to posting a discussion here. Patience is appreciated!

       

      I'm using LiveCycle Designer ES2. I've got a table with a column I would like to add all the cells in the column to a total in the bottom row of the table.

       

      There are 12 cells to add up. The first value of $25 is fixed, and is never to be changed by the user. In binding, I have named the field "Fed1".  I've set it as a Numeric field, type: Read Only, and default to 25.

       

      The rest of the cells will be fillable by users. I have named these cells Fed2, Fed3, Fed4, Fed5, Fed6, Fed7, Fed8, Fed9, Fed10, Fed11, Fed12. These have been set to Numeric Fields and are user-entered - optional.

       

      I want all cells Fed1 through to Fed12 to add up and display the total in the bottom cell, whch I have named "FedTotal".

       

      I have tried FormCalc and variations of Javascript but cannot seem to get any sort of calculation at all.

       

      FormCalc:

      I've tried: Sum(Fed1, Fed3, Fed4, Fed5, Fed6, Fed7, Fed8, Fed9, Fed10, Fed11, Fed12)

      I've tried: Sum(10527, Fed2, Fed3, Fed4, Fed5, Fed6, Fed7, Fed8, Fed9, Fed10, Fed11, Fed12)  but I receive errors that the cells cannot be determined.

       

      Javascript: I've tried so many scripts, there are too many to list here.

       

      I'm writing the code on the calculate event, written on the Fed13 object.

       

      Please help!