
1. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
try67 Apr 11, 2013 10:28 AM (in response to Coyotefankw)Just set the SubTotal field to be the sum of the itemfields, and then set the tax field to equal 0.015 (to get 1.5%).
Then for the Total field use this as the Simplified Field Notation code (under the Calculate tab):
SubTotal * (1+Tax)
You will need to make sure, though, that Total is calcluated after SubTotal in the field calcluation order.

2. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
gkaiseril Apr 11, 2013 10:37 AM (in response to Coyotefankw)You may want to separately state the tax collected for full disclosure the the client and the taxing authority. The client may need to tax separately stated for other purposes and the taxing authority might require it.

3. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
Coyotefankw Apr 11, 2013 12:09 PM (in response to try67)Thanks try67,
I think that worked, I submitted it to my client for testing.
This is just the push i needed to go take a javascript class next semester.
Thanks Again!
Coyotefankw

4. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
try67 Apr 11, 2013 12:32 PM (in response to Coyotefankw)I'm glad to hear it, but you should know that the code I provided is not
written in JS...

5. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
Coyotefankw Apr 15, 2013 11:26 AM (in response to try67)Hi try67,
that formula that you gave didn't work. Any other suggestions??? I'm getting desperate for a solution, client getting upset. Anything you can suggest would be most helpfull.
Thank you,
Coyotefankw
"Just set the SubTotal field to be the sum of the itemfields, and then set the tax field to equal 0.015 (to get 1.5%).
Then for the Total field use this as the Simplified Field Notation code (under the Calculate tab):
SubTotal * (1+Tax)
You will need to make sure, though, that Total is calcluated after SubTotal in the field calcluation order."

6. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
gkaiseril Apr 15, 2013 11:54 AM (in response to Coyotefankw)What were the input values and what were the calculated totals?
Try adding or changing one of the detail items and see what happens?
If it is computing the any expected value for the previous data, then your field calculation order is wrong.
Open the Acrobat JavaScript (Ctrk + J) console and see if there are any messages.
Actually JavaScript is being used to perform the calculations. Using either of the firs 2 options is just providing parameters to a JavaScript function that performs the calculation per the supplied parameters.

7. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
Coyotefankw Apr 15, 2013 12:11 PM (in response to gkaiseril)Yes here azre the errors:
Acrobat EScript Builtin Functions Version 9.0
Acrobat Annotations / Collaboration Builtin Functions Version 9.0
Acrobat Annotations / Collaboration Builtin Wizard Functions Version 9.0
Acrobat SOAP 9.0
SyntaxError: invalid assignment lefthand side
1:Field:Calculate
SyntaxError: invalid assignment lefthand side
1:Field:Calculate
ReferenceError: RateSubTotal is not defined
1:Field:Calculate

9. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
gkaiseril Apr 15, 2013 12:30 PM (in response to Coyotefankw)For RateSubTotal:
RateRow1 + RateRow2 + RateRow3 + RateRow4 + RateRow5
For RateTax:
RateSubTotal * 0.015
For RateTotal:
RateSubTotal + RateTax
A generic form with the calculation 3 different ways.

10. Re: Newbie, I need to calculate 5 items to a Sub Total + Tax 1.5% = total fields
Coyotefankw Apr 16, 2013 1:30 PM (in response to gkaiseril)1 person found this helpfulGKaiseril  Thank you very much!
I get it now, your a Genius! You went above and beyond to help.
Your code worked beautifully! I couldn't be happier, my client is happy as well.
Sincerely,
Thanks!
Coyotefankw