Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GETPIVOTDATA with date in referenced cell
Hi. Using xl2000 on XP.
I've written the formula =IF(ISNA(GETPIVOTDATA(threewtpt,$A$2&" "& $A4&" "&$C$16))=TRUE,0,GETPIVOTDATA(threewtpt,$A$2&" "&$A4&" "&$C$16)) When I enter a date in $C$16, referring to a field containing date items, the formula returns an incorrect result of $0.00. When I change the field to one containing text and enter a corresponding text item in $C$16, the formula returns the correct result of $5.00. If I write the formula referring to the items using text, e.g. =GETPIVOTDATA(threewtpt,"'Seattle' 'BHL' Date[1/1/2008]), instead of cell references, it works just fine. I tried to exchange the $C$16 cell reference in the formula with Date[1/1/2008], but I get the same result of $0.00. Is there something I can do differently? Thanks, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA and Date-type field (Excel 2007) | Excel Worksheet Functions | |||
Return Results of a cell based on cell referenced in a cell | Excel Worksheet Functions | |||
GETPIVOTDATA with date in referenced cell | Excel Worksheet Functions | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions | |||
Can I get a day(eg.Monday) referenced from a date cell?(2/May/05) | Excel Discussion (Misc queries) |