Rolling Months.

[stevietm]

Hi Everyone

I have a pivot, and I am working out months rolling. All works fine when I work out 3months, 6months and 12 months rolling, but when I try to work out 9months rolling I get no Values back at all. Does anyone maybe know why this is happening??

This is the expression I am using =sum(if(Inmonths (3,Time, SetDateYear (LatestMonth, max (total Year (Time))), 0,2), Value)) ...

Kind Regards

And thanks in Advance