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

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

Toppers,

Sorry, I forgot to mention something. I'm trying to use a calculated field
in a PivotTable.

When I say column, I mean a column of data (which is also a field in the
PivotTable). So the data actually looks like:

Item_Num Yield_Item
1234 0.999993012
1234 0.999998289
1234 0.999986024
1234 1
1234 1
1234 0.999994371
1234 0.999979875
5679 0.999997148
5679 1
5679 1
5679 0.999979294
5679 1
5679 0.999992842
etc...

Now, I want the Product of Yield for a particular item number. When I use a
calculated field as mentioned, I get 6.999951571.

However, if I show field Yield_Item and change the field settings to display
as Product, this I get 0.999951571 (which is what I want to get).

I don't know how I'm getting any number over 1 as all numbers in the column
(field) are 1 or less.

Hope that helps.

Jay

"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

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