To use the function
Change values
, you first need to select a range of data cells that does not contain any attributes (such as distribution keys). You can then change the values in the selected range using the functions
Revaluate
and
Add
.
Revaluate
This function increases the values in the selected cells by a percentage that you enter. You can also enter a negative sign, in which case the values in the selected cells are decreased by that percentage.
Add
The
Add
button lets you add the value you specify in the
Value
field to the values in the selected cells. Again, you can enter a negative sign, in which case the value you entered is subtracted from the previous values.
Note
If you want to reverse the
Change values
function, choose
Undo entries
or the pushbutton
(see
Clear Row, Undo, Redo
).