Current and Previous Quarter

[alec1982]

Hi,

I have atable that has Quarter as follow:

Quarter

2011/1

2011/2

2011/3

...

...

..

2013/4

2014/1

...

I need to define the Current and the previous Quarter based on today's date..

Anybody has a solution?

Thxs

[mphekin12]

You can try using Autonumber().  Here is an article that might point you in the right direction:

     Set Analysis: Nested If Statement into Set Analysis

[Josh_Good · Accepted solution]

Try this expression:

Today's Quarter:

=Year(Today()) & '/' & Ceil(Month(Today())/12*4)

Last Quarter:

=Year(AddMonths(Today(),-3)) & '/' & Ceil(Month(addMonths(Today(),-3))/12*4)

[#4]

Hi,

     If you want Quarter Date then use:

       QuarterStart (Today())          //For Quarter Date

      QuarterName:    QuarterName(Today())          //For Quarter Name

For Previous Quarter:

          QuarterStart (Today(), -1)      // For Quarter Date

        QuarterName:    QuarterName(Today(), -1)            //For Quarter Name

If your requirement not fullfill then please attach any sample file for more clarification.

Regards,

Ashutosh

[VishalWaghole]

Hi,

PFA attachment....

Thanks and Regards,

Vishal Waghole

[#6]

Hi, Try This hope it will help

Dimension: Quarter

Expression:

=Sum({<CommonDateField={">=$(=Date(QuarterStart(vMaxDate, -1)))<=$(=Date(floor(QuarterEnd(vMaxDate))))"}>}Sales)

Variable:

vMaxDate: =Date(max(CommonDateField),'DD/MM/YYYY')

[#7]

Hi,

Try below:

Current Year and Quarter  = Year(QuarterStart(Today()))     & '/' & Ceil(Month(QuarterStart(Today()))/3)

Previous Year and Quarter= Year(QuarterStart(Today(),-1))  & '/' & Ceil(Month(QuarterStart(Today(),-1))/3)