Pivot Table Calculated Field Math Error

[jcranst]

I have just created my first Calculated Field. I created two to show Normal Hours and Overtime hours. These work great. I then tried to created a 3rd which does the following: (Normal Hours*Rate)+(Overtime Hours*1.5*Rate). The math I get is wrong. Is there a problem with referencing the values obtained from a Calculated Field for calculations?

[JosephP]

calculated fields always do the math on the sum values which means your formula calculates as

(SUM(Normal Hours)*SUM(Rate))+(SUM(Overtime Hours)*1.5*SUM(Rate))

rather than

SUM((Normal Hours*Rate)+(Overtime Hours*1.5*Rate))