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