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

adding calculations on separate page

Forum Index > Forms: LiveCycle Designer > adding calculations on separate page
2008-03-14 08:32:40
annac
Registered: Mar 13 2008
Posts: 8
Answered

Despite reading the other posts and tutorials, I cannot seem to get this. Can you help me simply add totals from 3 different pages onto a grand total last page?

I don't understand SOM, I have looked in the hierarchy palatte and made sure the field with the cal. is at the bottom....Of course, I am under a schedule and I need it yesterday.....ugh.

I have tried naming all the fields in the column the same "P1", the total boxes at the end of each page are all named the same "Total1". I tried setting the binding to global...I am sure I am missing some small thing in the script or a palatte selection.

Can you smell the desperation?!!

Any help would be greatly appreciated.

thank you,
Anna

My Product Information:
LiveCycle Designer, Windows
Top
2008-03-15 23:54:22
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Unfortunately, there is no way to give you a specific answer whithout knowing the exact hierarchy of your document.

However, here is a clue. If the top level of the form is named "form1" which is usually the default, and all of the fields that need to be added up are named "Total1", then this code should due the trick.

Sum(form1.*.Total1)

This FormCalc scipt will add together every field on the form that's named "Total1", regardless of where the field is in the hierarchy.

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

Top
2008-03-17 23:35:37
#2
hbella
Registered: Mar 10 2008
Posts: 10
hi thomp

i'm sure you can help me out on this one.
i want number fields to have a default number as "R 000,000,000.00"
and i'm inserting this - Z999 and ($Z,ZZ9.99) on the display pattern.
The thing actually i want to have the output to be in this format
"R 000,000,000.00" but having digits that were inputed.i'm not sure if my regionals are correct. but the currency symbol is set to R.

THANX

hbella
Top
2008-03-18 07:24:50
#3
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4307
This is off topic, you should get more responses if you make a new post with an appropriate title.

George Kaiser

Top
2008-03-19 05:39:19
#4
annac
Registered: Mar 13 2008
Posts: 8
Thomp:

Thank you so much. I had to go in and rethink the layout and decided to just have one Total box at the end. I used your formula and played with it until it worked.This is what I came up with:

Sum(topmostSubform.*.Price[*])

It works! Thank you very much for your time and help.
Top