2 Replies Latest reply on Sep 2, 2010 5:13 AM by pguerett

    Subtraction across different pages help please




      I am new to this forum and hope someone can help.


      I have created a form in Livecycle ES2 and have many formcalc sums working fine.


      My problem is my subtraction calculation gives me a minus total equal to one of the cells it is suppose to be subtracting from.


      For example I have


      A is the total of 5 cells = $250,000




      B = total being 1 cell * 75% of another = $100,000


      C = A + B = $350,000




      D = Total of 7 cells = $100,000


      (All formulas up to here are working perfectly)


      E is supposed to equal C - D


      My total is always the total of cell D as a minus e.g. -$100,000


      C is on page 1 and D is on page 2


      I have in my xfa the page numbers and the field names correct and get no errors when previewing, it just gives me the incorrect total.


      xfa.resolveNode("form1.page1.GROSSCOVERREQUIRED") - xfa.resolveNode("form1.page2.TOTALRELISABLEASSETS")


      Can you help me out with a formcalc formula to get E to = C - D please.


      Any help would be much appreciated