Results 1 to 4 of 4

Thread: Help with Formula referencing a Pivot Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2019
    Posts
    162
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Help with Formula referencing a Pivot Table

    I just have a quick question about a formula I have that is referencing a pivot table. In some areas the pivot table will not have data yet. How can I modify the below formula that if there is an error, to display a blank cell?

    =GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38

    I tried:

    =IFERROR(=GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38),"")

    But Excel does not accept this and says I have an error somewhere.

    Your help would be much appreciated.

    Thank you very much.

    Carla

  2. #2
    Board Regular steve the fish's Avatar
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,645
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Help with Formula referencing a Pivot Table

    You dont have the 2nd equals sign.
    Looking for opportunities

  3. #3
    Board Regular
    Join Date
    Jul 2019
    Posts
    162
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with Formula referencing a Pivot Table

    Sorry that was a typo.

    This formula still does not work:

    =IFERROR(GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",8,"Approval Status","Granted","Years",2019)/Graphs!L38),"")

  4. #4
    Board Regular
    Join Date
    Jul 2019
    Posts
    162
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with Formula referencing a Pivot Table

    Nevermind, I figured it out. The formula is:

    =IFERROR(GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date Returned",7,"Approval Status","Granted","Years",2019)/Graphs!L37,"")

    Had an extra ) that didnt belong.

    Thx.

Some videos you may like

User Tag List

Tags for this Thread

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
  •