Rolling forecast based on last three months

[idogridish2]

Hi,

Trying to create a forecast based on the last three months (In the Layout, not the script, the customer asks for it to be dynamic),

the issue as I see it is that we need to use the calculated forecast values for the continued forecast,

please see the attached Excel file, you will understand better,

[idogridish2]

Hi,

I managed to do it for three months,

see the attached QVF file,

can we improve this? because it's kind of complicated.

Ido.

[Chanty4u]

Try this

.Avg({<Date = {">=$(=Date(AddMonths(Max(Date), -3)))<=$(=Max(Date))"}>} Sales)

[idogridish2]

Hi, thanks, 

did you try it on the app I provided?

[Chanty4u]

I don't have access to the application sorry

[idogridish2]

The app is open for everyone, there is no section access.