Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field Total in Pivot Table
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field Total in Pivot Table
Paste the contents of the cell here for inspection
Arleen wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field Total in Pivot Table
Field calculates January Salary Budget where "Jan Plan" is my Headcount.
='Jan Plan' *(Salary /12) "Bob I" wrote: Paste the contents of the cell here for inspection Arleen wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field Total in Pivot Table
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!! "Arleen" wrote: Field calculates January Salary Budget where "Jan Plan" is my Headcount. ='Jan Plan' *(Salary /12) "Bob I" wrote: Paste the contents of the cell here for inspection Arleen wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field Total in Pivot Table
I think you will need to do the math before you hit the Pivot table.
Arleen wrote: 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!! "Arleen" wrote: Field calculates January Salary Budget where "Jan Plan" is my Headcount. ='Jan Plan' *(Salary /12) "Bob I" wrote: Paste the contents of the cell here for inspection Arleen wrote: 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field Total in Pivot Table
Thanks for the reply -- not really the answer I wanted but I figured as much.
"Bob I" wrote: I think you will need to do the math before you hit the Pivot table. Arleen wrote: 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!! "Arleen" wrote: Field calculates January Salary Budget where "Jan Plan" is my Headcount. ='Jan Plan' *(Salary /12) "Bob I" wrote: Paste the contents of the cell here for inspection Arleen wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Calculated Field, Running Total | Excel Worksheet Functions | |||
Pivot Table Calculated Field using Grand Total | Excel Worksheet Functions | |||
Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) |