****** HOW TO MAKE A ROLLING 3 MONTHS *******

@PRIOR

I am trying to create a formula in Period that will make a “rolling 3 months”.  So if I am the account Gross Profit on Jan, 2012, the total gross profit for the rolling 3 months will include Jan, 2012, Dec, 2011 and Nov, 2011.  All that I get is Jan, 2012.  What is incorrect with the formula?  The @PRIOR alone does not work either.

 

@PRIOR("Nov",-1,"Year") +

@PRIOR("Dec",-1,"Year") +

"Jan";

 

Thanks for any advice.

Never Mind.  I got it.

"Jan" +

@PRIOR("Dec",1, @LEVMBRS("Year",0) ) +

@PRIOR("Nov",1, @LEVMBRS("Year",0) ) ;