8 Replies Latest reply: Aug 17, 2012 5:25 AM by Ananth Raj RSS

    Rolling 12 months

    Dan-Ketil Jakobsen

      Hi all.

       

      I have a code that is supposed to show rolling 12 months based on selected period.

      example. Choose 201206 and the line graph should display from 201206 and 12 months back.

       

      The formula:

      sum({$<KVGruppe2={'%Rent'}>}{<Period ={">=$(=addmonths(Max(Period), -12)) <=$(=addmonths(Max(Period), 0,  'YYYYMM'))"} >}OutOfOuterLimit)

       

      But when I try this it goes all the way back to 200901.

       

      I tried to set dimmension to =if(period <StartPeriod, period)

      StartPeriod is allways period -12.

       

      Anyone see why?

       

      BR

       

      Dan

       

      Edited: Added an example