software

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 quot;Yield_Itemquot; 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

quot;Jayquot; wrote:

gt; Hi all,
gt;
gt; Well, I am now completely confused.
gt;
gt; I'm trying to use PRODUCT in a calculated field, and I can't get the proper
gt; number, and I'm hoping someone can point out my problem.
gt;
gt; The data in the field looks like this:
gt; 0.999993012
gt; 0.999998289
gt; 0.999986024
gt; 1
gt; 1
gt; 0.999994371
gt; 0.999979875
gt;
gt; If I enter those numbers in a cell and then calculate the product (ie.
gt; =PRODUCT(A1:A7)) then the answer is 0.999951571.
gt;
gt; I then want that to be a calculated field in a PivotTable. So, I place that
gt; data in a column called Yield_Item. I then enter as the formula
gt; =Product('Yield_Item') and the calculated field returns 6.999951571.
gt;
gt; Can anyone suggest a cause for this? I'm really at my wit's end. Any
gt; suggestons are greatly appreciated.
gt;
gt; Thanks,
gt; 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

quot;Toppersquot; wrote:

gt; Jay,
gt; When you say a column called quot;Yield_Itemquot; do you mean a named
gt; range? Using named ranges - either just A1:A7 or column A , it still get the
gt; same correct result.
gt;
gt; If you are using a whole column, it suggests there is data other than the
gt; A1:A7 data in the column as I can't see how else you would get your result.
gt;
gt; XL2003
gt;
gt; quot;Jayquot; wrote:
gt;
gt; gt; Hi all,
gt; gt;
gt; gt; Well, I am now completely confused.
gt; gt;
gt; gt; I'm trying to use PRODUCT in a calculated field, and I can't get the proper
gt; gt; number, and I'm hoping someone can point out my problem.
gt; gt;
gt; gt; The data in the field looks like this:
gt; gt; 0.999993012
gt; gt; 0.999998289
gt; gt; 0.999986024
gt; gt; 1
gt; gt; 1
gt; gt; 0.999994371
gt; gt; 0.999979875
gt; gt;
gt; gt; If I enter those numbers in a cell and then calculate the product (ie.
gt; gt; =PRODUCT(A1:A7)) then the answer is 0.999951571.
gt; gt;
gt; gt; I then want that to be a calculated field in a PivotTable. So, I place that
gt; gt; data in a column called Yield_Item. I then enter as the formula
gt; gt; =Product('Yield_Item') and the calculated field returns 6.999951571.
gt; gt;
gt; gt; Can anyone suggest a cause for this? I'm really at my wit's end. Any
gt; gt; suggestons are greatly appreciated.
gt; gt;
gt; gt; Thanks,
gt; gt; 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?

quot;Toppersquot; wrote:

gt; Jay,
gt; When you say a column called quot;Yield_Itemquot; do you mean a named
gt; range? Using named ranges - either just A1:A7 or column A , it still get the
gt; same correct result.
gt;
gt; If you are using a whole column, it suggests there is data other than the
gt; A1:A7 data in the column as I can't see how else you would get your result.
gt;
gt; XL2003
gt;
gt; quot;Jayquot; wrote:
gt;
gt; gt; Hi all,
gt; gt;
gt; gt; Well, I am now completely confused.
gt; gt;
gt; gt; I'm trying to use PRODUCT in a calculated field, and I can't get the proper
gt; gt; number, and I'm hoping someone can point out my problem.
gt; gt;
gt; gt; The data in the field looks like this:
gt; gt; 0.999993012
gt; gt; 0.999998289
gt; gt; 0.999986024
gt; gt; 1
gt; gt; 1
gt; gt; 0.999994371
gt; gt; 0.999979875
gt; gt;
gt; gt; If I enter those numbers in a cell and then calculate the product (ie.
gt; gt; =PRODUCT(A1:A7)) then the answer is 0.999951571.
gt; gt;
gt; gt; I then want that to be a calculated field in a PivotTable. So, I place that
gt; gt; data in a column called Yield_Item. I then enter as the formula
gt; gt; =Product('Yield_Item') and the calculated field returns 6.999951571.
gt; gt;
gt; gt; Can anyone suggest a cause for this? I'm really at my wit's end. Any
gt; gt; suggestons are greatly appreciated.
gt; gt;
gt; gt; Thanks,
gt; gt; Jay