RE: [PDF-Forms] Re-Calculation Problem

[Rob McDougall]

Just FYI – The new Adobe Designer 6.0 that’s in beta testing now creates forms that trigger an additional plug-in (the Adobe XML Architecture XFA plug-in).  Forms designed using the Adobe XML Architecture utilize a dependency engine similar to the ones used in spreadsheets so worrying about the order that calculations occur in should shortly become something we only reminisce about. J.   Regards, Rob __________________________ Rob McDougall, Technical Architect Indigo Pacific Limited   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Justice Gradowitz Sent: Tuesday, May 04, 2004 7:00 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PDF-Forms] Re-Calculation Problem   Amy-   You need to check your calculation order.   Advanced> Forms> Set Field Calculation Order   I had this problem on many of my forms until I started using this.  Basically make sure the flow of your calculations is right so if something is altered it doesn't mess up your other calcs.   Hope this helps.   Justice   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Sachs Sent: Tuesday, May 04, 2004 1:09 PM To: [EMAIL PROTECTED] Subject: [PDF-Forms] Re-Calculation Problem Hello everyone!  I hope you can help me with an issue I am having with one of my forms. The form in question is an itemized breakdown of credits and charges for an account.  There are 7 items which are considered to be credits.  There is a total field which shows the total of these 7 items.  There are then 18 items which are considered to be charges and again there is a total field which shows the total of these 18 items.  Finally the last field on the page calculates the total credits minus the total charges.  This form works well when the information is entered in an ordely fashion. However, if once all the information is entered a change is made to any of the credit or charge fields, the last field (credits - charges) does not recalculate.    So say, initially, we have a total of $1297.00 for the credits and a total of $1087.00 for the charges.  Credits (1297.00) minus charges (1087.00) equals a refund of $210.00.  Now the user realizes that she has entered $25.00 on item 2 for the credits which should not be there.  She deletes the $25.00 on line 2 so the total for credits recalculates to become $1272.00.  This in turn would cause the amount of the refund to be $25.00 less or $185.00.  The problem is that the refund of $210 still shows and does not recalculate if a change is made.   Is there some kind of script I can use which would prompt the last field to recalculate if any of the previously entered information is changed?  If anyone is confused or needs more information please let me know.  This form is used on a daily basis by many people so I would like to correct this problem as soon as I can.  Thanks in advance for any advice you can offer.   Amy Sachs  Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs