CODEWITHSUNDEEP
excelpivot-table
10110
10110

Reputation: 2665

Pivot Table's Calculated Field doesn't display Grand Total Correctly

I have the following Excel file: https://ufile.io/n9ed0

Which looks like this:

enter image description here

I have the calculated field Break Lateness to determine how late an "agent" is from his Break 1 by using the following formula:

IF( 'Break 1' > TIME(0,15,0) , 'Break 1' - TIME(0,15,0), TIME(0,0,0) )

The formula seems to work fine on cell range: C3:C12. But the Grand total in C2 and C13 is not correct.

I tried changing the time format but I'm unable to determine the reason why the sum is not being computed and displayed in the format I'd like.

Thank you!

Upvotes: 1

Views: 1188

Answers (1)

Vincent Gheur
Vincent Gheur

Reputation: 51

This is a known bug in Excel since many years... See here. I don't know when it will be solved.

I have tried to trick it, e.g. by creating an intermediate field holding the complex calculation, but this is not sufficient... (if I find a valid workaround, I will post it here).

Upvotes: 1

Related Questions