| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table calculated field error
In a calculated field in a pivot table, , this produces a #VALUE in
areas where in there is no(blank) data to calculate. (IOW, 'Total Sales Item Amt' can have blanks. Margin, in these instances is always a negative number. =IF(ISERROR(Margin/'Total Sales Item Amt'),"",(Margin/'Total Sales Item Amt')) Any ideas why? Pierre |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table calculated field error
On Jan 4, 10:56*am, Pierre wrote:
In a calculated field in a pivot table, , this produces a #VALUE in areas where in there is no(blank) data to calculate. (IOW, 'Total Sales Item Amt' can have blanks. *Margin, in these instances is always a negative number. =IF(ISERROR(Margin/'Total Sales Item Amt'),"",(Margin/'Total Sales Item Amt')) Any ideas why? Pierre Found it in the recipe book. Right click anywhere, table options, "for error values show", check and leave blank. Pierre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table calculated field | Excel Worksheet Functions | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Calculated field in pivot table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
