Trend

Applies to: Planning and Consolidation connections.

The trend feature takes a value or percentage and grows it by a factor among selected cells.

This feature places the source value in the first cell of the destination range. Each subsequent cell in the destination increases by the amount or percentage specified.

To perform a trend, select  Spread, Trend...  Trend  and specify the following items in the Trend dialog box:

• Source Value. Specify the initial value from which the trend begins.
• Specify a value or a percentage:
  • By Percentage: Specify a percentage of the previous value (previous cell) in the destination range. To create an increasing trend, use a positive percentage. To create a declining trend, use a negative percentage.
  • By Value: Specify an amount over the previous value (previous cell) in the destination range. To create an increasing trend, enter a positive value. To create a declining trend, enter a negative value.
• Destination. Specify the destination cells in which the system writes the results of the trend.
• Weights. This is optional. Specify a range containing weight values upon which to base the spread. This range must contain the same number of cells as the destination range. The source value is spread based on the selected weights. If you do not specify weights, the source value is spread evenly.
• Select one of the Trend Result options:
  • To take the trend amount to each cell and add it to any existing values already in the destination range, select the Add to Existing Values option.
  • To ensure that the amount trend to each cell overwrites the amounts in the destination cells, select the Overwrite Existing Values option.