Subtraction across different pages help please

[Former Community Member]

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

[Former Community Member · Accepted solution]

Your formulas look right .....can you send the form to LiveCycle8@gmail.com and I will have a look. Please include a description on how to reproduce the issue.

Paul

[Former Community Member]

Hi Paul,

Just emailed it to that address.

Thanks