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?