how to get previous Quarter

Tue, 25 Dec 2012 15:30:04 GMT

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

Re: how to get previous Quarter

Wed, 26 Dec 2012 05:30:54 GMT

Hi,

U have this('Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))) as field ryt?

if yes U can use previous function to get previous Quarter like below

=previous(Quarter)

~Kabilan K.