Results 1 to 4 of 4

How to get rid of #Div/0 in pivot table

This is a discussion on How to get rid of #Div/0 in pivot table within the Excel Questions forums, part of the Question Forums category; I have got a calculated field in a pivot table, the formula doesn't accept the if(iserror(.......) command. Is there a ...

  1. #1
    New Member
    Join Date
    Feb 2003
    Location
    NorthEast of England
    Posts
    47

    Default How to get rid of #Div/0 in pivot table



    I have got a calculated field in a pivot table, the formula doesn't accept the if(iserror(.......) command. Is there a way to handle this type of error in a pivot table?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339

    Default Re: How to get rid of #Div/0 in pivot table

    Click to the pivot table Options menu and check the 'For error values, show:' box, leaving it blank if you don't want to display anything.

  3. #3
    New Member
    Join Date
    Feb 2003
    Location
    NorthEast of England
    Posts
    47

    Default Re: How to get rid of #Div/0 in pivot table

    Thanks for that.

  4. #4
    New Member
    Join Date
    Nov 2010
    Posts
    10

    Default Re: How to get rid of #Div/0 in pivot table

    Not sure if this comment will ever be read but I just came across this over 10 years later and found it also of great assistance.

    So powerful this forum. Thanks all to those who contribute and make it so.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com