How would I adjust this formula so it sends back blanks (instead of zeros) when there are blanks in the pivot table its pulling data from?
=GETPIVOTDATA("GAS",'1Q10_Pivottable'!$A$3,"API_NO",'1Q10_Pivottable'!A6,"PROD_DATE",DATE(2010,1,1))
How would I adjust this formula so it sends back blanks (instead of zeros) when there are blanks in the pivot table its pulling data from?
=GETPIVOTDATA("GAS",'1Q10_Pivottable'!$A$3,"API_NO",'1Q10_Pivottable'!A6,"PROD_DATE",DATE(2010,1,1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks