4 Replies Latest reply: Jul 21, 2011 9:07 AM by Razor Ramon RSS

    Calendar Quarter Query

      Hi guys,

       

      I am trying to get a Quarter value to work as expected. I have created a master calendar which I am using for my application.

       

      I use  'Q'&ceil(Month(CalendarDate)/3) as CalendarQuarter to create the Calendar Quarter, but my requirement is for the Calendar Quarter to reflect the last value in the quarter, so Q1 2011 value should be the value in Mar 11 and not the sum of the values in Jan 11, Feb 11 and Mar 11.

       

      Has someone done something similar or does anyone have any idea how I can implement this in my application?

       

       

      Thank you