Acrobat Form not calculating values

[E_Mire@adobeforums.com]

BN - I use a field created within the form that is read only with the default value of .505. Then calculate the product of the mileage field and the read only field I created. When the mileage amount changes you only have to change the default value of the read only field for future use.

Rose - You just have ot follow your calculation fields to see what they are pointing to.

[imagine8_girl@adobeforums.com]

Hi. I am having problems creating my form. It is for ordering wine. The user enters in the amount of bottles they wish to purchase, and the form calculates the price based on a default value for the wine. All OK there. Problem is, I have two columns, one for Wine Club price and one for Recommended Retail price. I have the form set up to SUM both these prices (so it doesn't matter which is entered) and put the result in a Total field. This calculation is almost always incorrect, as if it keeps a prior input value in cache and pops it in the calculation when it isn't supposed to be there. I feel like I want to hit the refresh button! Actually, if I delete the value in the Total field and hit the return key it then does the calculation correctly, however this is no good to me as the user won't do this and therefore they will write a cheque out for the incorrect amount!

Is there was a way to upload my form? It's so hard to explain...

[George_Johnson@adobeforums.com]

You need to set the field calculation order to what makes sense for your form. The menu item for this depends on which version you're using. In Acrobat 7, it is: Advanced > Forms > Set Field Calculation Order

George

[imagine8_girl@adobeforums.com]

Thanks George! But I can't find it in version 9.0.0
Can you point me in the right direction?

[imagine8_girl@adobeforums.com]

I found it! You're a legend! Thanks! :-)

[scottdsnyder@adobeforums.com]

Had the same problem, now solved thanks to you. I've always had this problem and could never figure it out. I feel like one of the mysteries of the universe has been solved.

The interweb is full of miracles.

[Marc]

Hi,

For Acrobat 9.

Forms>Add or Edit Fields
When it is in editing mode:
Forms>Edit Fields>Set Field Calculation Order

Make sure your final total Field is the very last item in the list.

Marc

[Unregistered]

Hi,

I am working in Adobe Acrobat 8. I have no problem designing a form that requires a single calculation, but when I try to create one that draws on calculated sums to get a total, I seem to have problems. It may be related to the Field Calculation Order. However, the problem in my case is that this function is not enabled in the form I am working on, while it is enabled in other forms. Any thoughts on why this function is disabled? Tab Order is enabled, but not Field Calculation Order. I appreciate any insight.