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?

The grand total and subtotals for a calculated field will use the same
calculation as the other rows, instead of summarizing the data.

As a workaround, you could calculate the total events late outside of
the pivot table. Or, add a field to the source data, to calculate if the
event was late. Then, add that field to the pivot table.

CherylS wrote:
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?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com