5 Replies Latest reply: Nov 2, 2011 3:54 PM by robert2011 RSS

    Reporting using quarters when 1st quarter starts in March?

      How can I modify the usual script method for defining quarters (below)  so that it works when the first quarter starts in March? (ie Jan and Feb are Q4?)



      Mapping LOAD

      RecNo() as Month,

      'Q' & ceil(recno()/3) as Quarter

      AutoGenerate 12;


      Wondering if there is a quick workaround just by defining a map so that I list  1 = Q4, 2= Q4, 3=Q1, 4= Q1 etc, but I can't find the syntax.


      Any help much appreciated