Calculated Field Total in Pivot Table

[Arleen]

I have a calculated field that contains the (*) multiplier in the formula.
The data populates properly, however the "Grand Total" which I have set up as
a "sum" does not sum up properly.

Total works fine if I don't have the (*) in the calculated field formula.
Any ideas how I can fix?

 

[Bob I]

Paste the contents of the cell here for inspection

 

[Arleen]

Field calculates January Salary Budget where "Jan Plan" is my Headcount.

='Jan Plan' *(Salary /12)

 

[Arleen]

Bob -- I just figured out how "Grand Total" Calculates:

It does:

Sum('Jan Plan')*Sum(Salary/12)

-- which is not what I want it to do. I intend it to be Sum(Jan
Plan*(Salary/12))

Thanks!!

 

[Bob I]

I think you will need to do the math before you hit the Pivot table.

 

[Arleen]

Thanks for the reply -- not really the answer I wanted but I figured as much.