21 Replies Latest reply: Aug 18, 2015 8:42 AM by Peter Cammaert RSS

    Future date(s) and variables

      Hello all,

       

      Hopefully someone can help me with my problem. I want to make a forcast of some data.

      I have: DayNumbers, WeekNumbers, MonthNumbers and YearNumbers in my qvw.

       

      I want to create a forcast for one week ahead (now week 34 so want to see week 35). This works for now, but how do I create this if week 52 OR 53 goes to week 1. How do I set the year number +1 ?

       

      What I did:

      Variable: vNextWeek / =Week(Today())+1

      Set analysis: sum({$<Categories={'SLA'}, WeekNumber={$(=vNextWeek)}, Afdeling={'Infrastructure System'}, YearNumber={'2015'}>}Gewerkte_Uren)

       

      Thanks for thinking with me.