Thread: [Solved] Formfield calculation
View Single Post
 
Old 03-07-2013, 04:07 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Joachim View Post
I have one formfield (cost1)where I multiply two other formfields, works fine.
I have a second formfield (cost2) where I multiply two other formfields, works fine as well.
In a further formfield I add the two products (=cost1+cost2). The result is always the double of the correct number (like 20+10=60 instead of 30).
This is a known, long-standing bug in calculation formfields. Use formula fields for the calculations instead.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote