Skip to main content
September 12, 2016
Answered

Calculation cell is one step slower

  • September 12, 2016
  • 1 reply
  • 562 views

Hi, I am using Acrobat XI Standard to create a form.

Cell NameCell Value
A11
A22
A33
A4=A1+A2+A3

For example, if I put 1 in Cell A1 and 2 in A2 and 3 in A3, I want A4 to calculate A1+A2+A3=1+2+3=6. My problem is, when I put in 1 in cell A1, A4 shows 0, when I then put 2 in cell A2, A4 shows 1. Then I put 3 in A3, A4 shows 3 which is the sum of 1+2 (A1+A2). The calculation seems to be one step slower than my input. So when I finish entering, A4 shows 3 which should be 6. If I want it to be correct, I need to make another action, like put 0 in another cell so A4 would calculate A1+A2+A3 instead of just A1+A2.

It only happens to several columns and other columns are fine, I checked settings and properties in both cells and they are the same, so I don't know how to do it.

My laptop is windows 10 pro version 1511, processor is Intel(R) Core(TM) i7-5500U CPU @ 2.40GHz 2.40 GHz. System type is 64-bit operating system, x64-based processor.

Please let me know how to solve this problem. Thank you.

This topic has been closed for replies.
Correct answer George_Johnson

This is a typical symptom of an incorrect field calculation order. While in form editing mode, select:

Tasks > Other Tasks > Set Field Calculation Order

and arrange the fields in the order that makes sense.

1 reply

George_JohnsonCorrect answer
Inspiring
September 12, 2016

This is a typical symptom of an incorrect field calculation order. While in form editing mode, select:

Tasks > Other Tasks > Set Field Calculation Order

and arrange the fields in the order that makes sense.

September 13, 2016

Thanks, I fixed the orders and it worked. I have one more question. I got report from coworker that the calculation field calculated wrong. For example, the sum of the cells should be 565.23 but somehow it showed 565.31. At first I think it might be the calculation order problem. But I don't have any cell that contains a number of 0.08, so I don't know why there's a difference of 0.08. It only happened to one coworker and other people didn't get this problem, and when I tried to make the error happen again I couldn't and I got the right one. He printed the sheet out for me and the calculation cell was with a wrong number. The calculating field is locked so there's no way he can change the calculation. Is there any possible reason why he got the wrong number?  Thanks.

Inspiring
September 13, 2016

That's hard to say without knowing the exact values of the input fields. How did you set up the calculation exactly?