5 Replies Latest reply: Nov 19, 2012 9:00 AM by Tim Hop RSS

    Problem with week numbers

      Hi All,


      I have a straight table which i am forcasting figures for 10 weeks.

      I have a seperate calendar for my weekly forcast and i have set up variables for the 10 weeks. i.e.


      vWeekSelection = ForecastCal_Week

      vWeekSelection+1 = ForecastCal_Week+1

      vWeekSelection+2 = ForecastCal_Week+2



      the problem i am having is with the expression labels of the chart.

      for each label i am using the variable.

      so if i select the current week (46), i get the correct week numbers up to 52, but then the next expression lable is showing 53 when i want it to go back to 1

      Does anyone know what i can do to correct this please?