Macro to Copy Average Demand into Safety Stock Key Figure
I need your help for creation of a macro to meet a requirement, stated below:
We are releasing Demand on daily bucket for a period of 3 months. We would like to maintain safety stock only for the period of 21st date fo the month to 30th day ( for each months, within the storage bucket). For doing this I need to calculate average demand of the month based on the Forecast of 20th of the month. My requirements are:
Step 1: Read the Forecast value for 20th day of the Month
Step 2: Calculate Average demand based on the Demand of 20th day
Step 3: Populate Average demand in the Safety Stock fey figure from 21st to 30th of the month. For other days safety Stock key figure value shall be populated according to the Product Master value.
I have created following Macro, but it is not serving my requirement. Could you please tell me where I am going wrong: