2 Replies Latest reply: Feb 27, 2017 8:42 AM by Beck Bakytbek RSS

    create a monthcounter

    Beck Bakytbek

      Hi Folks,


      i have one question, namely regarding a mothcounter in master calender, i want to have a numbered consecutively lilke

      Jan, Feb, Mrz. Apr, although Jan = 0, Feb= 25,

      in my example (see attached) my orders begins with Month: Feb,


      for this issue, i use this code:



      Mapping LOAD

      RowNo() as Month,

      'Q' & Ceil(RowNo()/3) as Quarter

      AutoGenerate (12);




      min(Datum) as minDate,

      max(Datum) as maxDate

      Resident main;


      Let varMinDate = num(Peek('minDate',0,'Temp'));

      Let varMaxDate = num(Peek('maxDate',0,'Temp'));

      DROP Table Temp;




      $(varMinDate) + IterNo()-1 as Num,

      Date($(varMinDate)+IterNo()-1) as TempDate

      AutoGenerate 1 While $(varMinDate) + IterNo()-1 <= $(varMaxDate);


      [Master Calendar]:


          TempDate as Datum,

          AutoNumber(TempDate) as MonthCounter,

          Week(TempDate) as Week,

          Year(TempDate) as Year,

          Month(TempDate) as Dim_Month,

          Day(TempDate) as Day,

          ApplyMap('QuarterMap',month(TempDate),Null()) as Quarter,

          Week(WeekStart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

          WeekDay(TempDate) as WeekDay

      Resident TempCalendar

      Order By TempDate ASC;

      Drop Table TempCalendar;




      how can i resolve this issue? Thanks a lot in advance