Pivot Table - Calculated Field Trouble

[Serene]

Hi everyone,

I have created a calculated field in Pivot Table - "EffectiveBonus".
This field is based on the "Bonus" field in the main table and will pro-rate bonuses if minimum tenure if not fulfilled.

However, it appears that the sum of "EffectiveBonus" field remains the same as that of the Bonus Field despite the fact that the details of each row is different.

I have done a manual calculation and it appears that the sum of EffectiveBonus is incorrect.

Can anyone throw light on the sum of calculated fields and what might have gone wrong?
Thanks in advance,
Serene

 

[Kyrre]

Hi everyone,

I have created a calculated field in P
Serene

Please post a dummysheet, it`s easier to figure it out . However, it is a summerproblem in the valuefiled.