Prev: Hearty Congratulation – Jacob Sir
Next: Sharing workbook error message
From: ms on 16 Apr 2010 13:28
I have learned to use GETPIVOTDATA to retrieve numbers aligned with employees
names. When an employees name does not appear on the pivot table, it returns
#REF!, which can be turned into 4 with the ERROR.TYPE command. I can turn
the 4 into a 0, but then when the number is not a 4, I get #N/A.

Is there any way to get a 0 off of the pivot table if an employee name does
not show up?
From: Tom Hutchins on 16 Apr 2010 13:53
You can wrap the GETPIVOTDATA formula inside another function to return zero
if GETPIVOTDATA returns an error. In Excel 2007 you can use IFERROR:

=IFERROR(GETPIVOTDATA(...),0)

In Excel 2003 & earlier, you can use an IF(ISERROR( construction:

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

Replace ... with the arguments for your GETPIVOTDATA formula.

Hope this helps,

Hutch

"ms" wrote:

> I have learned to use GETPIVOTDATA to retrieve numbers aligned with employees
> names. When an employees name does not appear on the pivot table, it returns
> #REF!, which can be turned into 4 with the ERROR.TYPE command. I can turn
> the 4 into a 0, but then when the number is not a 4, I get #N/A.
>
> Is there any way to get a 0 off of the pivot table if an employee name does
> not show up?
 | 
Pages: 1
Prev: Hearty Congratulation – Jacob Sir
Next: Sharing workbook error message