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