Adjusting Values in Data Cells

You can adjust the value of one or more data cells by a specified number or percentage if the cells contain numerical data.

Note:

If you adjust the value of a cell that contains an Excel formula, the adjusted value overwrites the formula.

Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

To adjust data values:

  1. Click the data cell that contains the value to adjust.
  2. From the Smart View ribbon, select Adjust.
  3. From Adjust Data, select an option then enter the number or percentage by which you want to adjust the value of the cell.

    Available options are:

    • Add fixed value to selected cell(s)

    • Subtract fixed value from selected cell(s)

    • Multiply selected cell(s) by a fixed value

    • Divide selected cell(s) by a fixed value

    • Increase selected cell(s) by a fixed percentage

    • Decrease selected cell(s) by a fixed percentage

  4. Click Adjust Data.