Running calculation totals when adding pages

[RusticRanger2]

http://www.funkylogic.co.uk/equity.pdf

In a nutshell what I want to achieve is this: a cleint may own several properties, and have different percentage holding on each. Each property has a separate page of questions (the PDF above is that page). The first part of the equation is to calculate up the total equity in the property (TotEquity), and then based on the percentage holding (TotInterest), work out the individuals equity share for that property (TotalB). The form has the option to tell us about another property (addInstance), and we then have a second page with its own calculations and a new TotalB. This TotalB then becomes a running total for all pages added. Please can anyone help??

[Niall_O_Donovan · Accepted solution]

Hi,

Here is a version of the form: https://acrobat.com/#d=b*01ko6g2gn8Jqns9D1Hhg

It shows how to loop through the instances of Page1. It does not appear to be working correctly (by my eye anyway). I am not convinced of multiplying the two values in the script.

Hopefully it will give you a direction.

A couple of things: I would not be inclined to name pages with a capital 'P' (Master pages are 'Page1'), I tend to name design pages as 'page1'. The font you are using is adding to the file size. Something like Myriad Pro is much smaller.

Niall

[RusticRanger2]

Methinks you are a genius!! I will get this full tested. I will also look into the font issue, but I have little choice as this page is part of a 28-page official government form, and they tend to be very picky about the font.

Regards

Rob

[RusticRanger2]

This has been tested and found to be the correct solution. Our problem was that we were looking at it from the subform level, and not the higher level of the page. So many thanks.

[Niall_O_Donovan]

Great!

On the font issue I would recommend LC Designer Forms by JP Terry (http://smartdoctech.com/) and Forms that Work by Caroline Jarrett (http://formsthatwork.com/).

Serif fonts work well in printed material, but sans-serif work better for electronic forms.

Good luck,

Niall