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

Expression Help: Average/Total Forecast from Date X to Date Y

edited Jan 13, 2021 9:45AM in Supply Chain Planning and Collaboration 4 comments

Content

Hi Gurus,

We have requirement to calculate average/total forecast from Date X to Date Y. Any inputs would be appreciated.

Month Forecast Start Date End Date Avg Fcst
01-01-2021 100 01-01-2021 06-30-2021 400
02-01-2021 200 01-01-2021 06-30-2021 400
03-01-2021 250 01-01-2021 06-30-2021 400
04-01-2021 300 01-01-2021 06-30-2021 400
05-01-2021 350 01-01-2021 06-30-2021 400
06-01-2021 1200 01-01-2021 06-30-2021 400
07-01-2021 800 07-01-2021 12-31-2021 633
08-01-2021 500 07-01-2021 12-31-2021 633
09-01-2021 550 07-01-2021 12-31-2021 633
10-01-2021 600 07-01-2021 12-31-2021 633
11-01-2021 650 07-01-2021 12-31-2021 633
12-01-2021 700 07-01-2021
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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