Help with Formula referencing a Pivot Table

[willow1985]

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

 

[steve the fish]

You dont have the 2nd equals sign.

 

[willow1985]

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),"")

 

[willow1985]

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.