anderson_markus
New Member
- Joined
- Apr 5, 2013
- Messages
- 3
I have one field that writes different values depending if you in a pivot table choosed year, month, week or day as a headline.
Everything but day works. It displayed weird value instead.
The code I´m using is:
=IF(ISNUMBER(B4);CONCATENATE("Year ";B4);IF(ISNUMBER(B3);VLOOKUP(B3;'Calculate Call Avoided.xlsx'!Month;2;0);IF(ISNUMBER(B2);CONCATENATE("Week ";B2);IF(ISNUMBER(B1);CONCATENATE("Day ";B1);""))))
The date is in folowing format 2013-02-04 (YYYY-MM-DD) and the datefield that the pivot table retrieves the dates from has Date format.
Allthough you will find here next how it looks when I´m trying to display the Day headline (This example is when I choosed the date 2013-02-04): Dag 41309.
How can this be fixed?
Everything but day works. It displayed weird value instead.
The code I´m using is:
=IF(ISNUMBER(B4);CONCATENATE("Year ";B4);IF(ISNUMBER(B3);VLOOKUP(B3;'Calculate Call Avoided.xlsx'!Month;2;0);IF(ISNUMBER(B2);CONCATENATE("Week ";B2);IF(ISNUMBER(B1);CONCATENATE("Day ";B1);""))))
The date is in folowing format 2013-02-04 (YYYY-MM-DD) and the datefield that the pivot table retrieves the dates from has Date format.
Allthough you will find here next how it looks when I´m trying to display the Day headline (This example is when I choosed the date 2013-02-04): Dag 41309.
How can this be fixed?