Getpivotdata - if no data exists

[boxsterman]

Hi all,

If I use the Getpivotdata function to look up some information in a pivot table, can I get the answer to give me a 0 "zero" in the field if the data does not exist as opposed to #REF error message?

Cheers.

 

[Andrew Poulsom]

Generally ...

=IF(ISERROR(GETPIVOTDATA(Arg1,Arg2)),0,GETPIVOTDATA(Arg1,Arg2))

 

[boxsterman]

Thanks so much for your help. It worked perfectly.