Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Try this
.Avg({<Date = {">=$(=Date(AddMonths(Max(Date), -3)))<=$(=Max(Date))"}>} Sales)
Hi, thanks,
did you try it on the app I provided?
I don't have access to the application sorry
The app is open for everyone, there is no section access.