Hi members,
I need your help and advice on below issues.
I am trying to create a forecast accuracy report.
One universe contains the weekly forecast feeds with FCST As Of Date the 2nd universe contains the net revenue data with Ship Date. The net revenue can be daily.
My challenge is more about calculating/summing up the net revenue data between dates.
My 1st question: Do I need to merge FCST as Of Date with the Ship Date?
I am struggling with the formula to calculate the sum of shipped lines for the the next 7 days.
For an easier calculation, lets say 1k are shipped on below dates.
Result:
FCST of Date Qty Ship Window Shipped
4/2/2021 10k 4/9/2021 6k
4/9/2021 5k 4/16/2021 2k
Raw Data:
FCST of Date:
4/2/2021 – 10k
4/9/2021 – 5k
Net Revenue Date with following Ship Dates
4/1/2021
4/2/2021
4/3/2021
4/5/2021
4/6/2021
4/7/2021
4/8/2021
4/11/2021
4/16/2021
Thanks for any advices