Formfield calculation

[Joachim]

Hi,

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).

I have changed every available option forth and back, no chance.

By the way if I add the two products (like =text1*text2+text3*text4) the result is correct.

Is there an explanation or help available to get the correct sum of cost1 and cost 2?


Thanks in advance.
Joachim.

[OTPM]

Hi Joachim
Have you tried putting brackets around the first two formulae first of all to ensure those calculations are done BEFORE you try and SUM to two totals.
Hope this helps.
Good luck.
Tony

[Joachim]

Hi Tony
thank you for the quick reaction. I may not have explained correctly so to clarify an example (all names are formfields):
text1: 2; text2: 4.00; cost1=text1*text2, result: 8.00
text3: 3; text4: 5.00; cost2=text3*text4, result: 15.00
total = cost1+cost2, result 46.00 (instead of 23.00)

It would be great If you or somebody else could have an other look at the problem.
Could it be a flaw in Word 2007?

Regards
Joachim.

[macropod]

Originally Posted by Joachim

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.

[Joachim]

Originally Posted by macropod

This is a known, long-standing bug in calculation formfields. Use formula fields for the calculations instead.

Hi Paul,
thank you.
Joachim