Sum Not Working - Not Calculation Order Issue

[BlueFarie]

I created a budget worksheet for clients that totals the numbers they enter. The first client to use it sent it back to us, and the data she entered did not total up. The form she worked on is attached. Any idea why it didn't work for her?

The original form does total data entered when I try to recreate her data entry, so I'm guessing it is a version issue, or maybe she used a different .pdf viewer. If that is the case, maybe there is something I can do to the form to make it more versatile?

Thank you!

[Bernd Alheit]

The client should fill the form with Acrobat Reader or Adobe Acrobat.

[BlueFarie]

Thank you for your help 🙂

[lorenzor43688325]

I had an issue like that once before. You are using the simple math calculations; so was I, to fix it I had to de-select all the variables and select them again to fix it. I just tried that on your sample work sheet and it worked. Also, the annual amounts are calculated on the one you attached. I used the sample work sheet and it is working. 

When you define the value of the annual amounts, you will have re-define the calculation of the subtotal.

[BlueFarie]

Thank you! I did change a lot of the field names near the end of my work on the form. I am going to try this step first.

[Thom Parker]

There is nothing wrong with the form. I agree with Bernd, the client probably did not fill it out in Acrobat or Reader. 

If you change a field on the form filled by the client (any field), does on the form do the calculation?

[BlueFarie]

Yes, the form does the calculation for me. Thank you for your help.

[gkaiseril]

You have no formula for the "ConvertedTotal1" field. So if one had a total for the yearly expenses, it is not converted  to a monthly average. For that calulation you will have to write a custom JavaSript calculation.

[BlueFarie]

The formula for that field is to multiply the total in the Annual Total field by the content of field 0833, which is set to a default vaule of 0.0833. All of that is a very convoluted way to get Adobe to divide the Annual Total by 12. Thank you for taking the time to reply!

[try67]

You can just divide it by 12 directly... No need to use a separate field for that.

[try67]

Beside all of the above I would also recommend avoiding naming fields with just digits. It is a great way to cause errors when you use the Simple Field Notation option, as it doesn't know that "12" is the name of a field, not a number...

[BlueFarie]

Thank you for the tip!

[calm_moon3874]

Hi, 

By the time, i'm replying, you must a pro pro. Still, this is for someone like me, who is a novice, and looking for a solution. 

For the "subtotal" field on page one,

Open it's "Properties"

Click "Calculate" tab

Click the second radio button from top saying "Value is the 'sum' of the following fields"

Click "Pick" tab and add the fields you want to add in the ORDER they are in the form. (I repeat, in ORDER)

(In this form, fields were probably selected using "Shift", so they came in like Month1, Month10, Month11.... hence the problem. They need to be added Month1, Month2, Month3.... as they are in the form).

As I told you, I'm a novice, still looking how to multiply the 12 months in second column. 

Thanks. 

[calm_moon3874]

Gotcha.. found the answer after two secs of posting. Ridiculous. ROTF