How do I hide hide #REF! in Excel

[PerryK]

I have a pivot table that summarize sales by manager.

I am using the "=GETPIVOTDATA" function to capture the data into a table.

The table lists the managers name in column A and the summary data from the
pivot table in column B

One of the managers has not had any sales so far this year, so they do not
show up in the pivot table. This causes the #REF! error in the table.
I would like for it to show "0" or just be blank instead of it showing #REF!.

Is there an easy way to hide this error?

Thanks

 

[Jim Thomlinson]

There is an error function called IsRef. So something like this...

=if(isref(getpivotdata(...), 0, getpivotdata(...))

 

[PerryK]

Jim,

thanks --That did it!
--
Perry K

There is an error function called IsRef. So something like this...

=if(isref(getpivotdata(...), 0, getpivotdata(...))

 

[Jarek Kujawa]

one way might be:

=IF(ISERROR(GETPIVOTDATA(...)),0,GETPIVOTDATA(...))