Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PivotTable Grand Total Error using Calculated Field
I've created the following Calculated Field formula in my PivotTable to
capture the number of events that were late. DaysLate is the difference between the target completion date and the actual date completed. =IF('DaysLate'1,1,0) The formula works great and places a 1 where appropriate. However, the Grand Total is incorrect in that is always displays 1 also instead of totaling the column. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculated Field using Grand Total | Excel Worksheet Functions | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
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) |