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

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