bug in excel 2012/pivot/summation of calculated field

I have a calculated field (called TO) in a pivot

= if(time >= 600,1,0)

where time is a field.

I present it in 'values' with 'sum'. It shows correct values, but the sub-totals are wrong. I can send an example if you tell me where to...

January 30th, 2015 10:45am

It's not a bug, it's a consequence of the way calculated fields work. You should read your formula as

=IF([subtotal of time in pivot table]>=600,1,0)

To calculate what you want, add a column with formulas to the source data of the pivot table.

Free Windows Admin Tool Kit Click here and download it now
January 30th, 2015 2:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics