This moving average seems to have a lot of ways to be done, but must of them seems to be specific (for example only one possibility like a 3 month average).
To solve this, I decided to build a "some balance sheet account forecasting cube" with the !monthyear approach provided by scott, because I needed account forecasts using a 3, 6 and 12 moving average, a moving average formed by a monthly change percentage for the last six months, and a forecast based on a 12 months approach that determined a % to be applied. My formulas work perfect, because i only have to write them and feed them once (doesnt matter they are long, they are working!), but the hellish part is that i have to make 2 DB's (in and out between cubes) and the concerning feeders for each balance account i want to forecast. I also believe is a good answer because i have 10 companies with the same formula.
I dont like a lot this solution, probably i can do some reengeneering in the way I send accounts between cubes, but MOVING AVERAGE and SUMs formulas seems to be a tough twinkie to eat in !year and !month approaches.
Enlight me, please!!!
Regards,