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

Average of Subtotals in Pivot Table 0
Pivot Table % calculation 1
Pivot Table - Calculated Field 2
Calculation of Gross Margin in a pivot table 1
Totals of calculated field in pivot table give incorrect results 6
Calculated fields in pivot tables 5
pivot table 1
2007 Pivot table Calculated field misbehaving 1

Top