Comparison year Vs year before

[ecabanas]

I'm using this function to calculate the revenues for present year

=num(Sum({<[YEAR]={$(VYear)}>} Amount))

I would like to know the same but the year before, I put -1 in the variable but it doesn't work, anybody knows why?

=num(Sum({<[YEAR]={$(=(VYear)-1)}>} Amount))

Thank's for your help

[CELAMBARASAN]

Hi,

Can you tell me what is there in VYear?

[MayilVahanan]

HI

Try like this

=Sum({<Year = {'$(=max(Year)-1)'}>}Sales) for maximum -1 year

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

[ecabanas]

VYear is a variable: =(year)

[ecabanas]

Doesn't work Mayil...

[sujeetsingh · Accepted solution]

Hi if you are using Master Calender  than use following set equation

sum( {$<Year = {$(vLastYear)}>} Sales )

[nirav_bhimani]

HI,

U can try this. Its working

( sum({<FinancialYear = {"$(=Max(FinancialYear))"}  >}Sales) )

-

( sum({<FinancialYear = {"$(=Max(FinancialYear)-1)"}  >}Sales) )

Regards,

Nirav Bhimani

[ecabanas]

Now it works!!! I load Master Calendar and now it works perfectly

thank you everyone!!!