Pivot Table - simple question

  • Thread starter Thread starter s boak
  • Start date Start date
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
 
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)
 
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
 
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...
 
You must log in or register to reply here.

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 Help - Gross Margin % & % of Sales 2
Pivot Table Help - Gross Margin % & % of Sales 1
How to save "Empty" as Pivot Table calculated item result, or else...?? 2
Pivot table calculated field Count(field) / sum(field) 0
pivot table calculated field 1
Access #Error & Excel Pivot 0
Pivot Table Grand Total Issue 3
Turning Data into a Table 1

Back
Top