cumulative value

[Anonymous]

How to get cumulative values for 2 years.

i.e. i am getting cumulative value from jan-08 to Dec 08.

But the cumulative for Jan -09 should be addition of Dec -08 + Jan 09 and so on..

Please Help.

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

You can use AddMonths() function, that will return all previous 12 months

LET vDateFrom = AddMonths(Today(), -12);

Hope that helps

[Anonymous]

I want to calculate cumulative values from Dec 2008 to Mar 2010.

I am able to get cumulative from Jan 09 to Dec 09 and also from Jan2010 to Mar 2010,

but
not able to add dec 08 values to jan 09 .