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

    Subtract calculation in an expanding table?




      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.