Current Year and Previous Year Calculation in one Expression

[#1]

Hi,

I want to calculate current year and previous year in one expression. Bascially:

if I have MonthYear as Sept 2013 then:

for Current year: it should start from July 2013-Sept 2013

for Previous year: it should start from July 2012-Sept 2012

I am using this formula it gives correct value for current year but for previous year it calculates the whole year (July 2012-June 2013). I want it to stop at Sept 2012.

=Sum({<CalMonthYear=,Date={">=$(=Date(Yearstart(Max(Date),-1,7),'MM/DD/YYYY'))<=$(=Max(Date))"}>}Cases)

Any help?

Thanks.

[MK_QSL]

For Current Year

SUM({<MonthYear = {">=$(=Date(AddMonths(MonthYear,-2),'MMM YYYY')) <=$(=Date(MonthYear,'MMM YYYY'))"}>}SALE)

For Previous Year

SUM({<MonthYear = {">=$(=Date(AddMonths(AddYears(MonthYear,-1),-2),'MMM YYYY')) <=$(=Date(AddYears(MonthYear,-1),'MMM YYYY'))"}>}SALE)

Change appropriate field name as per your data model..

i.e. SALE to Cases, MonthYear to CalMonthYear