Show TOC

 Change Values Locate this document in the navigation structure

Use

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 .

Features

  • 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 Note

If you want to reverse the Change values function, choose Undo entries or the pushbutton ( ) (see Clear Row, Undo, Redo ).

End of the note.