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?)

       

      QuartersMap:

      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