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