Pivot table calculated field error

P

Pierre

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
 
P

Pierre

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
Click to expand...

Found it in the recipe book. Right click anywhere, table options, "for
error values show", check and leave blank.

Pierre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculated Field 0
Pivot Table - Calculated Field 2
2007 Pivot table Calculated field misbehaving 1
Add AVERAGE column to Pivot Table 0
Pivot Table Comparison 0
Pivot Table % calculation 1
Calculation of Gross Margin in a pivot table 1
Pivot Table Calculated Field using Grand Total 3

Top