In the forecast worksheet there are three Total columns.
Total Budget View the total value from the budget. You can perform a snap to budget (see below) which makes the total budget value equal to the Actual+Forecast value. when clicked on it shows the budget that was published and the Flagpole is not shown
Actual+Budget column - Actuals and Budget will be streams. Representing Actuals (to the left of the flagpole) plus the original budget (to the right of the flagpole). - Cells are not editable - no flagpole - discussion required on whether the budget is pulled from the published stream, or from the underlying workbook? → From budget stream
Actual + Forecast column - Forecast is what you’ve cloned in. If the ‘actual + Forecast’ column is selected then the cells to the right of Flagpole are editable - default selected Representing: This starts off the same as the actual + Budget column, but is editable so the customer can overwrite / change / add new data, new formulas etc
Clicking on either the actual + Budget or the actual + Forecast column will switch to the budget or forecast.
In the forecast worksheet, the flagpole indicates the latest current actual as defined in the forecast setup window. The flag pole is draggable and changes the data from actual to forecast/budget - values change in columns on drag
The Actual and Forecast column headers are different colors, so you can easily determine if a column displays actual or forecast values. A colored line indicates the actual portion of the forecast. The color of the column headers, flag pole and line changes, depending on the position of the flag pole and the total column that is selected, as illustrated in the images below.
This line also changes color depending on the position of the flag pole and the total column that is selected, as illustrated in the images below.