Rangesum issues.

[#1]

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.

[swuehl · Accepted solution]

I believe you need to add the 0,12 section as arguments to the below function, not to the rangesum, to achieve what you want, so just move one closing bracket:

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

[#3]

Well that was it, I feel like an idiot now.

Thank you for your help as always.