When I use Word's legacy form textbox fields to calculate, I get an incorrect result if one of the fields referenced in the calculation is also a calculation field.
For example, Let's say that I want these three fields:
1. Text1: Price
No Formula
Type: numeric
2. Text 2: Tax
Formula =Text1*.08
Type: calculation
3. Text 3: Total
Formula =Text1+Text2
Type:calculation
I did a YouTube video on this
here if my description makes no sense.
What is happening, is that starting in Word 2007 and for every version since, at step 3, the value from step 2 is doubled.
So if I put $10 in field Text1, I get $0.80 in field Text2 (that's good), but instead of getting $10.80 in field Text3 like I believe I should, I get $11.60, which = 10+80+80. It's adding the "calculation" field twice.
Am I doing something wrong? Is anyone else getting this "double" result?
To get around it, I changed the formula in Text3 to redo all the math: =Text1+(Text1*.08). This works, but can be a big pain in complex formulas that reference multiple calculation result fields and I
swear I never had this happen in Word 2003 or older.
What has me doubting my sanity is that this happens to me every time in the newer versions of Word, on many different computers, but I'm not seeing mention of it on the internet.
Please help me!
Many thanks.