IF #REF then display 0

[sprintorders]

I am using a PivotTable, and using the GETPIVOTDATA formula to popluate
data on a separate worksheet. The colums are days of the month, but if
i don't have any data for that date it gives me a #REF. Is there a way
i can include with my GETPIVOTDATA statement, that if it shows an error
or #REF, it will displya a 0 or leave it blank, that way it doesn't
mess up with the other data.

Let me know if you need any additional information.

 

[Guest]

How about

=if(ISERROR(getpivotdata()),0,getpivotdata())