Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! in PivotTable using Calculated Field
I'm working with a calculated field in a PivotTable. The formula I am using
in the calculated field is below. The value in one row for UL is 0.2471 and the value for LL is 0. I am getting #VALUE! for the result in the PivotTable. I am actually getting the Reject value if I perform the same function outside of the PivotTable. Can anyone help me understand why I'm getting this error in the PivtoTable, but not getting it outside the table? =IF(OR(UL<0.5,0.5<LL),"Reject","") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
Special Calculated field for PivotTable | Excel Discussion (Misc queries) | |||
Pivottable adding calculated field? | Charts and Charting in Excel | |||
PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
PivotTable - Calculated Field | Excel Worksheet Functions |