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

    Subtraction across different pages help please

    Nik707

      Hi.

       

      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

       

      Then

       

      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

       

      Thanks