Use special characters to edit the values in an embedded worksheet
You can edit the values of the cells in an embedded worksheet, using the
special characters such as ##, +, /, -, or %. This allows you to add or
subtract a value or a percentage to the existing value.
Note: You can only edit cells that are displayed with an underline.
Examples:
- To the original value of 200, specify ##+10% to add 10% to the original value; new value 220.
- To the original value of 200, specify ##+10 to add 10 to the existing value; new value 210.
- To the original value of 200, specify ##-10% to subtract 10% from the existing value; new value 180.
- To the original value of 200, specify ##-10 to subtract 10 from the existing value; new value 190.
This option is applicable only:
- If a value is already specified for the cell.
- If you are editing a measure that is defined in the rv_measure_calc parameter, the spread measure defined for the rule is used. If not, the existing spreading measure is used.