You have actual year-to-date ASP's (to April). You wish to copy that YTD ASP into a forecast file for the period May to December.
You can do this in the Standard Forecast Editor as follows:
- Select all Sales items at level of detail = Item Code + Grand Total (to avoid sub-totals)
- Select all cells (excluding Grand Total) for May - Dec
- Select Data > Apply Calculations
- Apply roll forward average with value = 0.0
Please sign in to leave a comment.