Return "0" instead of "N/A" in Pivot Table reference

[jasonr704]

what's the best, easiest way to just return a "0" instead of N/A's when referencing data in a pivot table? what should I add to my formula below?

here's my current pivot table reference:
=GETPIVOTDATA("Sum of Component Total",'Bing-Rev'!$A$3,"Order date",DATE(2010,11,1),"Type","order_line_item")

Thanks!

[JWhite]

You should be triggering an error when the value isn't present so just add an "On Error" command that sends it to an instruction that sets the return value to zero if the GETPIVOT triggers an error.