pdf form calculation not calculating

[Jellevant]

I created a form yesterday - with the extensive help of a forum member - and thought it was fine until I checked it online.  I have a column of items with quantity x price = total, and a grand total at the end that adds the individual totals. 

Problem:  when I test it, it never picks up the last item entered (whichever one it is) and so the grand total is always wrong.  This obviously renders the form useless!

The form is at drronaldlevant.com/new/orderform.pdf.  Can anyone find the bug? 

BTW I used Acrobat 9 pro on a macbook.  Tested on mac and pcs, and friends' macs and pcs.  Same issue everywhere.

[George_Johnson · Accepted solution]

The problem is the field calculation order is incorrect. To correct it, go into forms editing mode (Forms > Add or Edit Fields) and then select "Forms > Edit Fields > Set Field Calculation Order" and set the correct order.

[Jellevant]

Unfortunately, it's not the order that is the problem.  I need to use the Extend Usage option so that users with pcs can save the completed form.  Once I do that, calculations AND other links cease to work. 

[Juliette Perales]

Changing the Set Field Calculation Order worked for me. Thank you so much for sharing.

[Joy0D4C]

Adobe DC just had an update. I can't find how to do the steps you recommend. Am I supposed to be in the PDF prepare form??? Where do I go to change the field calculation order?

[Nesa Nurani]

Yes, select 'Prepare Form' tool, then click on 'More' and then on 'Set field calculation order'.

If you have problems with new Acrobat layout, look here how to switch to old layout:

https://community.adobe.com/t5/acrobat-discussions/adobe-acrobat-pro-layout-is-different/td-p/133636... 

[Steven381302290liu]

I keep trying I have just my last formula not working correctly.  I have updated the calculation order but still will not give me the result.   I could really use some assistance I am loosing my mind on this.

[Bernd Alheit]

 Check the JavaScript console.

[try67]

If you did all the recommendations given here then share the file for further help.

[matthewe9273744]

The order was my issue, thank you.

[Guest]

Hi Jellevant

    I looked at your form here on my iMac with Acrobat 9 and it seems to total up correctly.

    Could it be  that when you enter the last quantity field you did not hit tab or click somewhere else on the page? The result doesn't show up until you hit tab or click somewhere.

    I redid some of the form to hide the zeros. Go here and see if it works.

http://nixmailmac.com/forum.pdf

Ron

[Jellevant]

Thanks for doing that.  My first attempt to use the form you made was on Chrome on my mac.  It did not work, so I didn't even try it on the pc.  The individual totals do change when the quantities are entered but the final total stays at 0.  The only button that worked was the Reset.  I couldn't save to computer, couldn't click through to paypal.  These are necessary functions for the intended users who will not likely own acrobat and most probably be on pcs.

What I've found is that testing correctly in Acrobat does not mean it will work once it's online.

The latest iteration is now drronaldlevant.com/new/orderform_kfmX.pdf if you have any other ideas.

[Yenhwi]

Thanks! I have the same problem and i just hit " enter " and it calculates fine!

[alancard]

I wonder if this is related to the problem I'm having (See Recent Form Calculation Problems here: http://forums.adobe.com/thread/872931?tstart=0).

If the calculations seem to work at first and then break once you've saved and re-opened the form, you might be battling the same bug I am, in which case no amount of attention to how your calculations are set up is going to fix anything.

For the past week, every newly-saved form I make (even just as extended-features-enabled copies of existing forms that work perfectly well) fails to calculate once I close it and re-open it.  I assume it's the result of some software update or another, but the truth is I have no idea.  --And apparently nobody else does, since no one responded to my post.-- But if you're suffering from the same problem, then your calculation set-up may be perfectly fine.  I've replicated the problem on a number of very simple test forms, as well.  They work fine... until I hit save, close them, and re-open them.  Then they're just inert.

Good luck!

Alan

[constanzek13919285]

Hi Alan, a few years have gone by since you had this problem, but i have exactly the same issue.

Quatitiy x Unit price = Total adds up fine when I create the form, but when I save it as a reader extended pdf the total of the Quantity and Unit price doesnt add up. Do you know why?

[ls_rbls]

Hi,

Before you save the source PDF to Reader Extended check the calculation order of your fields.

Can you share an example of your code or a screenshot of what you see in Acrobat when you're editing your calculations?

Also, please specify what PDF viewer is used to work with the Reader Extended PDF .

[josephs25635643]

I am having the same issue even using Adobe Reader.  While I change the order of the field calculations in Adobe Acrobate DC the form calculates fine.  Once I save and reopen the PDF the calculation skips the last entry made in the table.  Is there some global recalculation for the form that can be triggered each time a field is edited?

[Bernd Alheit]

Can you share the form?

[ls_rbls]

In Adobe Acrobat, hit the "Ctrl+J" to open the console and see what errors are indicated there. Then post back with a screenshot of what you see .

[Lawrence R]

Hi I'm having the same problems on a pc, did all the calcs rechecked went to preview filled in the form and the Sub total, tax and grand total don't update or recalculate it's a simple invoice ????

[Bernd Alheit]

Check the field calculation order.

[Kashif26802992duhm]

• Same problem is with my case.
• I am worried about this problem
• Please guide me anyone 

[try67]

Please share the file in question.

[Guest]

Hi Jellevant

    I took your latest form and gave it the extended features for Adobe Reader.

    I still can't find any problem with the totals.

    Here is the link.

http://www.nixmailmac.com/forumkfmx.pdf

    The only related issue I know of is that my Safari was in 64 bit mode and it would not read a calculation form I have online.  I think someone here said to go to Get Info on the Safari icon and open in 32 bit mode and it works fine now.

Ron

[Jellevant]

Well, that did ring a bell.  The pc I test on is a 64 bit machine.  However, I just tried your version of the form on my mac in Chrome and the calculations do not work.  Entering a quantity updates the individual total but the final total stays at 0.