| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Field Total formula not working
i created a calculated firled in my pivot table, but the for the grand total
column it is not calculating. it is calculating in all the other areas, just not the grand total columns. here is what it looks like: as you can see the #DIV/0! , the calculated field formula is Column C = (column A-Column B)/Column B it should state -0.5802 ((Same for Column F=(column D-E)/E) this should be -0.7284) A B C D E F 18752 44671 #DIV/0! 10542 38821 #DIV/0! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
| Missing Grand Total for a Calculated Field in a Pivot Table | Excel Worksheet Functions | |||
| Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
