Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Question: Final Bookings Forecast

edited Feb 10, 2020 6:55AM in Supply Chain Planning and Collaboration 5 comments

Summary

Question: Final Bookings Forecast

Content

We have an requirement to Sum up the values of 'Final Bookings Forecast' for past 12 months and also to sum up the values of 'Final Bookings History' for past 12 months and do some calculation.

We are able to sum the values of 'Final Bookings History' for past 12 months as this measure stores the Historical values.

How do we sum up the forecasted (Final Bookings Forecast) values of past 12 months? Since there are no values being stored in this measure when we move forward to next months?

Can anyone please suggest the approach to achieve this? This is critical requirement in our project.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!