Pivot Table ... DIV/0 ... Error

K

Ken

Excel 2000 ... I have an inserted calculated Field in my
Pivot Table ... Issue is, many of the cells in this Field
are returning "DIV/0" error.

Above said ... How do I setup Pivot Table to prevent
this??? Note: BLANKS would be fine ... Thanks ... Kha
 
G

Guest

Kha..
You probably need to change the formula in the calculated
item to account for zeros. Suppose you have a calculated
item with the formula "(y-x)/x" to calculate a variance.
If any of the "x" data items have a zero this will return
Div/0 errors. To get round it, use the formula
"if(x=0,0,(y-x)/x)".
Hope this helps
ID
 

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

how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot Table ... Suppress "0" Values? 2
Pivot Table Calculated Field - Sum/count 1
Pivot Table Calculated field error 1
#DIV/0! in a Pivot Table 1
Pivot Table #DIV/0! Error 3
Pivot Table Refresh? 1
Pivot Table Chart? 4

Top