| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using PRODUCT in Calculated Field
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
| how to create a calculated field from another calculated field? | Excel Discussion (Misc queries) | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
