PDA

View Full Version : Return "0" instead of "N/A" in Pivot Table reference



jasonr704
11-30-2010, 04:25 PM
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
12-01-2010, 08:30 AM
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.