I also noticed that the value of Product('Yield_Item') in a calculated field
is NOT calculating the product but is actually the SUM of Yield_Item.

Is there a way to change that?

"Toppers" wrote:

Jay,
When you say a column called "Yield_Item" do you mean a named
range? Using named ranges - either just A1:A7 or column A , it still get the
same correct result.

If you are using a whole column, it suggests there is data other than the
A1:A7 data in the column as I can't see how else you would get your result.

XL2003

"Jay" wrote:

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