These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Calculating totals in repeating rows

Forms
Registered: Dec 6 2007
Posts: 3

Hi
Not sure if I can explain my problem clearly enough but here goes.

I have a row (the row is contained in a subform called "Item"), this row contains 4 numeric fields. These are called
"ProjectTotal"
"EstimatedCost"
"Reimbursment" (which is a needs to be a percentage) and
"Total"

The "Total" field needs to run a scipt which will calculate the "ProjectTotal" by the "Reimbursement" field (eg. $10,000 x 30%) and the "EstimatedCost" by the "Reimbursement" field.

The amount that appears in the "Total" field must be the lesser amount of the two equations.

I need to be sure that when I add a new line (when I click on my "Add Row" button) that the newly created "Total" field doesn't read from the previous row but recognizes the new data on the new row. I hope this makes sense.

Any help would be greatly appreciated. Many thanks

Michael

lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
There is an example of how calculate the sum of fields nested inside a repeating subform at:
http://partners.adobe.com/public/developer/en/livecycle/designer/pdfs/FieldSum.pdf

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

jmarcos89
Registered: Dec 21 2007
Posts: 1
Is there an example for calculating subtotal per page in repeating rows?
tburnakis
Registered: Jun 7 2007
Posts: 1
I am having a heck of a time with a form I designed in Adobe Acrobat 9. It has a number of checkboxes in rows (20 rows of checkboxes, each row named the same but with different export values).

I was able to easily make a total box with Adobe Acrobat where, when the box was checked (or "on") the export value was used in the overall total. When all the rows were completed I had a total "score".

Since I want to be able to use this in Reader I went to LiveCycle and imported the form (so I could then enable reader rights). Everything transferred fine, the calculation came over from Adobe in Javascript, but the total field no longer works? Is there some trick I am missing? I am VERY new to this so it is entirely possible, but it worked so nice in Acrobat?

Thanks

Tom

Thomas Burnakis, Pharm.D.

lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
tburnakis wrote:
Since I want to be able to use this in Reader I went to LiveCycle and imported the form (so I could then enable reader rights).
You don't need to develop your form in LiveCycle Designer just so it can be Reader-enabled. You can Reader-enable a form you've developed in Acrobat.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.