no reference date #ref!

G

gongxia649

=GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C33,"store_code","023")

trans_date is the date in the transaction, c33 is the date. But i hav
no date which i can reference to, because of that it's displayin
#ref!. i want it to be '0' instead. how can i get around this
 
M

Marcelo

try,

=if(iserror(GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C33,"store_code","023"),0,GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C33,"store_code","023"))

hope this helps
Regards from Brazil
Marcelo

"gongxia649" escreveu:
 
T

T Kirtley

The PivotTable Options Dialog allows you to specify specific values to show
for empty cells or for error value.

Would setting a '0' as the value to show when no data exists do what you want?

HTH,

TK
 
Top