Help with Calculations

How do you currently have your form set up to perform the calculations?

Are you using Acrobat or LiveCycle Designer to create the form?

If I were in your position, I would require the people in accounting to give me explicit rules regarding how rounding should take place. Lacking that, we can only guess at solution. There are many rounding schemes that have been used in financial calculations.

In particular, you need to clarify what numbers like 3.765, 3.775, and -3.765 should be rounded to. Different rounding methods available in JavaScript can round these cases differently. Even if you're not dealing with negative amounts today, you may someday.

George

I laid out the form in Quark XPress, then exported it to pdf. Using Acrobat, I added the text and calculation fields. (Can I email the form to you so you can see how the fields are set up? It's not a proprietary document.) Not including personal information and text fields, I have an "Amount Payable" field and two columns titled "Indicate %" and "Calc Field." The Calc Field calculates the product of the Amount Payable and the Indicate % fields for each line of business.

To explain "line of business," our company consists of many different legal entities that follow different tax rules. So when an employee spends money and asks to be reimbursed, he must specify how much of the money should come from each entity or "line of business."

Dollar amounts should be rounded up to the nearest cent if they are over by 1/2 cent or more, or down to the nearest cent if they are under 1/2 cent more. For example, 3.765 should be rounded to 3.77, and 3.764 should be rounded to 3.76. I don't need to deal with negative amounts on this particular form because the user is requesting money to be paid to him--he is not paying money to the company.

Hope this helps. Thanks for your response!

To keep it simple in this case, you can set up a custom Validation script for each of your calculated fields:
event.value = util.printf("%.2f", event.value);
This takes the calculated value and rounds it to two decimal places. Normally, you'd include something like this in a custom calculation script, but since you're using the built-in calculation option, you can do this instead. Post again if this doesn't work for some reason.

George

Thank you, thank you!