This discussion is archived
1 Reply Latest reply: Mar 5, 2013 4:56 AM by Arrun RSS

Time Series Function-Ago

Arrun Newbie
Currently Being Moderated
Hi Guys,

I have an issue with the AGO function.
I have used a formulae some thing like below.

Ago("CCLRDC"."Fact - Balances Measures"."YTD Balance" , "CCLRDC"."Period"."Month" , 3)

Similarly like for month 2 and month 1.Well the point is I need a ytd bal for the prev 3 months and current month too.
When I pass the filter as APR-2012 im getting data for APR-12,MAR-12,FEB-12,JAN-12 But
When I pass the filter as MAR-2012 im only getting data for MAR-12,FEB-12,JAN-12 but could not get data for DEC-11

Please someone help me out .

Thank You,


  • Correct Answers - 10 points
  • Helpful Answers - 5 points