Consecutive Month

[#1]

Hi all, I´m trying to get the last month value and I can´t make it, could some body help me to get the consevutive month number or if you could help me to get the last month value I would be thankfull.

I attached the App.

Thanks!!

[mkirchhofer]

Hi,

have upated your last Month Column.

Regards Mario

[#3]

Thank´s mkirchhofer but the problem is when I select January 2012 in the las month value I should get December 2011 but it returns 0.

[mkirchhofer]

Ok,

than use

=chr(39)&Date(MonthStart(Max([Mes-Año]))-1,'MMM YYYY')&chr(39)

at variables instead.

[swuehl · Accepted solution]

Try this as expression:

sum({$<[Mes-Año] = {'$(=date(addmonths(max([Mes-Año]), -1),'MMM YYYY'))'}, Mes=,Año= >}[Valor Surcharge Nuevo])

[#6]

Excellent again swuehl.

Thank you both Guys!!

[#7]

One more last question guys, How could I get the previous Quarter?

do you guys know it?

[mkirchhofer]

Did you mean something like this?

I'm not sure about performance, maybe there's a better way!

[#9]

Yes!!, that´s what I needed it, Thank you both!!

Have a great one!!