0 Replies Latest reply on Jul 25, 2013 10:23 PM by Bradc82

    Subtract calculation in an expanding table?

    Bradc82

      Hi

       

      I am currently designing a form in Livecycle ES2 and am in need of calculation script.

       

      I have an expanding table with add rows on it.

       

      In the table i have a drop down list with 2 items that be can selected DR and CR, an Amount field and a total field.

       

      Currently the Amount field and a totals field adds up correctly with this script Sum(Spersonaldetails2.Table1.Item[*].Amount)

       

      However i now need the Totals field to calculate based on which item from the drop down is selected.

       

      So if DR is selected i need it to add to the total and if CR is selected i need to subtract from the total.

       

      One row could be a DR and the next row a CR.

       

      I am unable to have the totals field subtract the Amount if CR is selected.

       

      look forward to any help.  i have been wrecking my brain over this.