3 Replies Latest reply: Jun 7, 2016 6:07 PM by Sunny Talwar RSS

    Quarter Creation

    Akpofure Enughwure

      How do I create a quarter period in my script. Please find the attached file for clarity. Thanks

        • Re: Quarter Creation
          Sunny Talwar

          This:

           

          NoConcatenate

          LOAD [S/N],

               [Supply Field],

               If(Len(Trim(Region)) = 0, Peek('Region'), Region) as Region,

               Supplier,

               Type,

               [Daily Average],

               [Annual Cumm],

               Date(Num#(Date)) as Date,

               Month(Num#(Date)) as Month,

               'Q' & Ceil(Month(Num#(Date))/3) as Quarter,

               MonthName(Num#(Date)) as MonthYear,

               Year(Num#(Date)) as Year,

               Value