| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
no reference date #ref!
=GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C3 3,"store_code","023") trans_date is the date in the transaction, c33 is the date. But i have no date which i can reference to, because of that it's displaying #ref!. i want it to be '0' instead. how can i get around this? -- gongxia649 ------------------------------------------------------------------------ gongxia649's Profile: http://www.excelforum.com/member.php...o&userid=35346 View this thread: http://www.excelforum.com/showthread...hreadid=551186 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
no reference date #ref!
try,
=if(iserror(GETPIVOTDATA("NetSales",data!$A$1,"tra ns_date",C33,"store_code","023"),0,GETPIVOTDATA("N etSales",data!$A$1,"trans_date",C33,"store_code"," 023")) hope this helps Regards from Brazil Marcelo "gongxia649" escreveu: =GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C3 3,"store_code","023") trans_date is the date in the transaction, c33 is the date. But i have no date which i can reference to, because of that it's displaying #ref!. i want it to be '0' instead. how can i get around this? -- gongxia649 ------------------------------------------------------------------------ gongxia649's Profile: http://www.excelforum.com/member.php...o&userid=35346 View this thread: http://www.excelforum.com/showthread...hreadid=551186 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
no reference date #ref!
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 "gongxia649" wrote: =GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C3 3,"store_code","023") trans_date is the date in the transaction, c33 is the date. But i have no date which i can reference to, because of that it's displaying #ref!. i want it to be '0' instead. how can i get around this? -- gongxia649 ------------------------------------------------------------------------ gongxia649's Profile: http://www.excelforum.com/member.php...o&userid=35346 View this thread: http://www.excelforum.com/showthread...hreadid=551186 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| average value from a table | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
| & reference answering as Date Serial # not actual text | Excel Worksheet Functions | |||
Linear Mode
