Combining GETPIVOTDATA with IF function

[SChapman]

Hi,

I have the formula below:

=GETPIVOTDATA(" NCR",'[Performance.xlsx]Team Performance'!$A$10,"Full Name","Name,1")

I need to add an IF function into this so if the cell cannot pull the data & is returning #REF it shows as 0.

Any ideas?

Thanks

[Harribone]

=IFERROR(yourformula,0)

[SChapman]

Needed an additional ')' but worked a treat once that was included. Thank you!