12-month accumulation / How to?

[#1]

I have found some examples like YTD, therefore none of 12-month accumulation.

Per example, in filed Jun 2008 the sum would be "Jun08+May08+Apr08+Mar08+Feb08+Jan08+Dec07+Nov07+Oct07+Sep07+Aug07+Jul07".

Thank you!

[#2]

aletrindad -

You can create your rolling 12 month accumulation by using this formula

sum(if(inyear(MonthYear, $(vPeriod), 0, month(addmonths($(vPeriod), -11))), Failures))

In the code above you will need to set the vPeriod variable [Settings > Variable Overview > Add]

Hope this helps.

Tyson

[#3]

Hi Tyson,

was it the value vPeriod in Vaiablelist ?

do you have any QVD exampel for that?

Thanks.

[#4]

Hi Tyson!

I didn't understand the Variable vPeriod and also the relation between MonthYear and the Variable into inyear function.

I would be very gratefull, if you share with us, into the QVD file attached.

Thanks again!

[#5]

Hi,

see also this example (Set Analysis).

Good luck!

Rainer