Edit the Values in Forecast Plan

· There are 3 ways in which the user can change/edit the values in Forecast Plan.

  1. Edit Flag

  2. Double Click on Cell.

  3. Edit in Excel Sheet.

· To edit values in any Data Measure, the Edit Data option in the Data Measure Master must be set to True.

image-20210611154120761

· Run the Work Flow to view the Forecast Plan.

· Go to Menu Bar --> Forecast --> Forecast Plan.

· Select the combination of Product and Region in the tree structure. Double-click on the cells of Data Measure which are editable.

image-20210611154145998

· A window comes up in which the user has to change the value.

· The value can be changed in 4 ways,

  1. Add – The same value gets added to the existing value.

  2. Add Percentage – Add the percentage of the existing value.

  3. Quantity – Entered value reflects directly in the cell.

  4. Percentage – Enter the percentage of the existing value.

· Here we Add 361, which gets added to the existing value. The new value is 9000.

image-20210611154212707

· Once this is saved, the cell of changed value appears green.

image-20210611154224196

· Second method to edit the cell value is to click on Edit Flag and change the value.

image-20210611154313795

· Enter the new value and save it. The cell of changed value is coloured green and after the page reloads, the cell colour will be white like before.

image-20210611154325832

· Third way is to export the data to an Excel Sheet, Edit it and then Import it to the tool.

· Make sure the Data Type Should be ‘Data Measure as Column’. Click on Export Flag.

image-20210611154335052

· The Excel Sheet opens with the data to be edited. Change the value of Final Forecast from 25 to 30.

image-20210611154345005

· Save it and Import the sheet into the tool.

image-20210611154354972

· The Final Forecast gets updated with the new value.

image-20210611154406378