You can adjust the value of one or more data cells by a specified number or percentage if the cells contain numerical data.
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:
- Click the data cell that contains the value to adjust.
- From the Smart View ribbon, select Adjust.
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
- Click Adjust Data.