PivotTable calculated field causes crashing

[ET2000]

Hi all,

I couldn't figure this one out myself and could not find existing answer, so I thought whatta hell, I'll just join the forum and ask Gurus

So my problem is when I am adding calculated field to Pivot table and restarting the workbook it crashes.
Here is the formula I am adding as calculated field:
= ROUNDUP(AVERAGE( 'Delivery time' )+1,96 * STDEV.P( 'Delivery time' )/SQRT(COUNT( 'Purch.Doc.' ));0)

After restarting the workbook I get error:
An item name cannot be found. Check that you've typed the name correctly and the item is present in the PivotTable report.

Maybe there is something really simple I am missing about field names or so..

I am using Excel 2010.

Can anyone help? I'm gladly providing any additional information if needed.

BR,
ET

 

[RoryA]

Welcome to the forum.

Given that calculated fields always aggregate the data by summing, I don't think that calculated field is going to work anyway.