Present year previous year analisys

[ecabanas]

Hi,

I have a floor databae dates and the sales. I would like to make comparisons year Vs previous year. I did some variables:

VMaxDate =(max(DATEFINANCIAL))   this returns 41333 because Datefinancial is a floor.

VPriorDate = vMaxYear -1 this returns 41332

I would like to do calculations with this variables, but with this results I couldn't do, did you know how to solve this problem?

Thank's

Eduard

[sushil353]

use date function:

Date(VMaxDate) and for previous year : =addmonths(date(VMaxDate),-12)

[neha_shirsath]

Hi,

Please see below example-

For Previous Month:

Sum({<Month= {"$(=MonthName(addmonths(max(date),-1))"}>}Sales)

For Current Month:

Sum({<Month= {"$(=Monthname(max(date)))"}>}Sales)

[neha_shirsath · Accepted solution]

Hi,

Please make the corrections, the expression is as below-

For  Current Year :

Sum({<year= {$(=max(Year))}>}Sales)

For Previous Year :

Sum({<Year= {$(= max(Year-1))}>}Sales)

[#5]

Hi

For  Current Year :

sum({<PERIOD_YEAR={"$(=max(PERIOD_YEAR)"}>}[Net Amount])

For Previous Year :

sum({<PERIOD_YEAR={"$(=max(PERIOD_YEAR)-1)"}>}[Net Amount])

it works

[ecabanas]

Hi Neha,

The problem is when I want to apply the same logic to calculate the previous month!!

and doesnt work

Sum({<CalendarMonthName= {$(= max(CalendarMonthName-1))}>}IMPORTBRUT)

[#7]

Hi

use the below exp for the monthname condition

=Month( AddMonths(START_DATE,-1))

[neha_shirsath]

Hi ecabanas,

Means you want to calculate for current YearMonth and Previous YearMonth?

Like for Dec2012 and Dec2011..

[ecabanas]

yes, that's I want to do!!!!

[nirav_bhimani]

HI,

Try this for the last Year Month

Sum ({<Date = P({<Year={$(=max(Year)-1)}>}Date)>}Sales)

Regards,

Nirav Bhimani