Skip to Content
0
Former Member
Dec 17, 2008 at 02:23 PM

Text Variable for 0CALWEEK: On Structure with Calweek offset

143 Views

Good day

Please assist? I have gone through numerous SDN threads relating to the following, but could not find a solution for my problem.

1) User wants to see 16 weeks data in columns, each week in own column. I have created a structure for each week with offsets 0 to -16, 0 to -15 and so on to display data. User wants to '0' display even if no data was loaded for a certain week, thus the structure. The data is displayed for 16 weeks. Now I want to replace it with calendar week text. (I have used week 12 to test text variable. week 12 should be displayed as 'example' 2008/42)

2) There are no calweek text variables available for selection, so I created a new one as 'replacement path', characteristic "Calendar year/week" and 'replace variable with "Name (Text)".

2.1) The following is the result 12 &0DPM_WV1&. Not what I wanted.

Where am I going wrong?

Your assistance will as always, be appreciated.

Thanks

CJ