Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Adjust row amounts for a forecast

You can quickly adjust the amounts in your forecast by either a set value or a percentage. When you select either Increase or Decrease and then enter a number or percentage, the numbers in the rows of your forecast change accordingly.

Note: In the following table, the number 10 is just an example—you can use any amount or percentage.

Use

To

0.0%

Fill with the same amount.

10%

Increase each by 10%.

-10%

Decrease each by 10%.

10

Increase each by $10.

-10

Decrease each by $10.

To do this task

  1. Click in a cell in the forecast.

  2. Click Adjust Row Amounts.

  3. From the drop-down list, click either 1st month or Currently selected month.

  4. Specify whether to increase or decrease that amount for the remaining months by either a fixed amount or a percentage.

    Optional: If you chose Currently selected month in step 2, you can also select Enable compounding. This option compounds the number entered in the Increase or Decrease field across the selected months.

    Example:

    Compounding Original Amt. Jan Feb Mar Apr May
    Yes ($10) 100 100 110 120 130 140
    No ($10) 100 110 110 110 110 110
KB ID# H_FORECAST_F1_INCREASE_DECREASE
12/8/2016 1:51:41 AM
PPRDQSSWS407 9138 Pro 2017 f16e57