Pivot Table calculated field error

L

Lee

I have a calculated field in a pivot table in Excel 2007 that averages the
selling price of an item. The Columns are the years from 2008 to present,
Row Labels are items then by Customer Type, and the values are Quantities
Sold, Total Dollar Amount and the calculated field is the average selling
price (Dollars/Quantity).
The problem is that each item is not sold for every year and I get Div/0
error. When I try the following =if(Dollars<>0, Dollars/Quantity,"") the
#value error replaces the Div/0 error.
I looked at the Contexture website and didn't find any idea as to solve the
problem. Any help is appreciated.
Thanks,
Lee
 
R

Roger Govier

Hi Lee

Right click on PT>Table Options>Layout & Format>Format>Show errors
as>leave as blank
 

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

Excel Pivot Table 4
Pivot Table Calculated field error 1
Pivot Table Calculated Field - Sum/count 1
Pivot table calculated field Count(field) / sum(field) 0
Calculated Field Issue 9
Calculated Fields showing error results 1
2007 Pivot table Calculated field misbehaving 1
Calculated Fields in Pivot Table 2

Top