Pivot Table - simple question

S

s boak

Hi Folks:

I've set up a calculated field that expresses percent profit.
A number of the calculations evaluate to #DIV/0!.
Is there a way to remove/hide these ??

Thanks
Steve
 
A

ANdras

Hi Steve,

you can extend the calculated field's formula, with
=IF(IsError(formula_of_the_division);0;formula_of_the_division)

Hope, this helps..

Best regards,
ANdras
(Hungary)
 
D

Debra Dalgleish

Right-click on the pivot table, and choose Table Options
Add a check mark to 'For error values, show' and leave the box empty.
Click OK
 
S

s boak

Thanks Debra -
Way cool
SB

Debra Dalgleish said:
Right-click on the pivot table, and choose Table Options
Add a check mark to 'For error values, show' and leave the box empty.
Click OK
Click to expand...
 
Top