2 Replies Latest reply: Mar 5, 2012 3:33 PM by Marc Livingston RSS

    Rangesum issues.

      Anyone know what I am doing wrong here? I am trying to get a rolling 12 month sum, but seems to be just taking the previous months total and adding 12 to it?!?

       

      RangeSum(Below(sum([Sales  Revenue])),0,12)

       

       

      I thought the 0,12 section was telling it to go 12 months back and include the current month. (IE 11-2012 to 10-2011)

       

      What am I doing wrong? I can not use the accumulate 12 steps back because I need to use this expression in another expression and also uses a rangeavg.