Hi all,

Well, I am now completely confused.

I'm trying to use PRODUCT in a calculated field, and I can't get the proper
number, and I'm hoping someone can point out my problem.

The data in the field looks like this:
0.999993012
0.999998289
0.999986024
1
1
0.999994371
0.999979875

If I enter those numbers in a cell and then calculate the product (ie.
=PRODUCT(A1:A7)) then the answer is 0.999951571.

I then want that to be a calculated field in a PivotTable. So, I place that
data in a column called Yield_Item. I then enter as the formula
=Product('Yield_Item') and the calculated field returns 6.999951571.

Can anyone suggest a cause for this? I'm really at my wit's end. Any
suggestons are greatly appreciated.

Thanks,
Jay