Overview
In Sales Planning and Analysis databases you may choose the following options when using forecast editors:
- Data to be amended
- Data to be entered
See also Editing Cells in Forecast Editors and Saving Amended Values in Forecast Editors.
Calculation Logic
The following logic applies to these options:
| Data to be Amended | Data to be Entered | Calculation | Notes |
| Units | Units | Amended value = Amended units * existing ASP | |
| Value | Amended units = Amended value / existing ASP | Value cannot be entered in cells that have existing ASP = 0. Amended units are rounded to whole numbers when amended data are saved in the target file(s). |
|
| ASP | Amended units = Existing value /amended ASP | ASP cannot be entered in cells that have existing Value = 0 |
|
| Units & Value | Amended ASP = Amended value / amended units | ||
| Units & ASP | Amended Value = Amended units * amended ASP | ||
| ASP | Units | Amended ASP = Existing value / amended units | If amended Units = 0 then amended Value is saved directly without an ASP |
| Value | Amended ASP = Amended value / existing units | Value cannot be entered in cells that have existing Units = 0 | |
| ASP | Amended value = Amended ASP * existing units | ||
| Units & Value | Amended ASP = Amended value / amended units | ||
| Units & ASP | Amended Value = Amended units * amended ASP |
Comments
0 comments
Please sign in to leave a comment.