7 Replies Latest reply on Jul 31, 2012 10:50 AM by George_Johnson

Calculations gone wrong

Andopwr Jul 31, 2012 10:02 AM

I cannot for the life of me figure this out! I will satrt with, I am fairly new to this, but I can creat fields and edit them. However, every time I try and do simple calculation with "the value is" window i run it and things seem okay until I adjust other fields on the form to calculate as well. And then the previous fields get messed up.

I am wanting in the top portion, "Sub-Total" = ("Rate Per Night" x "Tax")

Then I want "Total" = ("Sub-Total" x "# Of Nights")

Then I want on the bottom:

"Sub-Total" = (90.00+30+30+30+30+30+30+30)

"Tax" = ("Sub-Total" x "Tax")

"Total" = ("Total [from top]"+"Sub-Total [from bottom]+"Tax"+"Svc Fee")

I went through the edit properties and calculated them but still they keep getting messed up or not even close. I know i may come across dumb but I need help.

Thank you.

please help me!!!!!

1. Re: Calculations gone wrong

George_Johnson Jul 31, 2012 10:10 AM (in response to Andopwr)

The first thing you need to do is make sure that the field calculation order is correct. Exactly how you do this depends on which version of Acrobat you have. First go into form editing mode. In Acrobat 9 you'd then select: Forms > Edit Fields > Set Field Calculation Order

In Acrobat 10, select: Other Tasks > Edit Fields > Set Field Calculation Order
Like Show 0 Likes(0)

Actions
2. Re: Calculations gone wrong

Andopwr Jul 31, 2012 10:27 AM (in response to George_Johnson)

Okay - I did that. I am working with Acrobat Pro 9
Like Show 0 Likes(0)

Actions
3. Re: Calculations gone wrong

Andopwr Jul 31, 2012 10:34 AM (in response to Andopwr)

I did the "set field calculation order" and I believe I have them in the right order. (top to bottom as they occur) but the problem is the fields change with any additions I make. Giving me crazy numbers.
Like Show 0 Likes(0)

Actions
4. Re: Calculations gone wrong

George_Johnson Jul 31, 2012 10:40 AM (in response to Andopwr)

Let's start with just one field. How do you have the Tax field that's at the top of the form configured to calculate, exactly?
1 person found this helpful
Like Show 0 Likes(0)

Actions
5. Re: Calculations gone wrong

Andopwr Jul 31, 2012 10:43 AM (in response to Andopwr)

I figured it out I was doing an extra step in percentages. you da man!!!!
1 person found this helpful
Like Show 0 Likes(0)

Actions
6. Re: Calculations gone wrong

Andopwr Jul 31, 2012 10:45 AM (in response to George_Johnson)

It was that tax field at the top! I just locked in and made it read only so noone can put a number in there. and as long as you add the correct percentage in the bottm tax field every time it, it should be good. Is there a way to give that bottom tax field a fixed percentage so it doesnt need to be typed in?
Like Show 0 Likes(0)

Actions
7. Re: Calculations gone wrong

George_Johnson Jul 31, 2012 10:50 AM (in response to Andopwr)

It's not clear to me how it needs to work exactly, but you can set a default value for a field and make it read-only.
Like Show 0 Likes(0)

Actions