1 Reply Latest reply: Dec 26, 2012 12:30 AM by Kabilan Kumarasamy RSS

    how to get previous Quarter

      I used the following formula to get the quarter selected

       

      = 'Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))

       

      so when i select a month it give me the quarter as  Q4,1012

       

       

      now if i want to get the previos quarter how can i do that. For the month its easy but for quarter no idea at all

       

       

       

       

      PLEASSEEEEEEE HELPPP