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
