If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table Data
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? |
#2
|
|||
|
|||
Pivot Table Data
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? |
Thread Tools | |
Display Modes | |
|
|