Scale values dialog

Applying scaling to data values alters them by the chosen scaling value. You can add, subtract, multiply, or divide by any non-zero number from -1E100 to +1E100. (That is, from -10¹⁰⁰ to +10¹⁰⁰.)

For example, for a data value of 12 and a scaling factor of 10:

• Add - adds 10. The scaled value is 22.
• Subtract - Subtracts 10. The scaled value is 2.
• Multiply - Multiplies by 10. The scaled value is 120.
• Divide - Divides by 10. The scaled value is 1.2.

Note: To edit a value on the scaling page, either double-click it or else select it and press F2. Then type or select the new value.

To apply scaling:

1. In Measure, choose the measure to which scaling will be applied.
2. In Scaling operator, choose an operator from the drop-down list.
3. In Scaling value, type a value. You can enter any number from -1E100 to +1E100.
4. If you wish, you can use the Number of decimals dropdown list to choose a number of decimals that is different from the default. For example, when scaling currency values you could choose to have more than two decimals to show partial cents.

   Note: The Number of decimals setting only takes effect if scaling is applied. It cannot be used to reformat numbers without scaling.

5. In Name (Or Name - Language), type a name for the scaled measure. If you do not provide a name, the default name will be used. For example, the default name "Sales / 10" indicates that the Sales measure's values have been divided by a factor of 10.
6. When you have finished, click Show updated report.

Notes:

• Some browsers will display a dialog asking if you want to allow the webpage to access your clipboard. You must allow access in order to apply scaling.
• Scaling can be applied to more than one measure at the same time.
• Value highlighting is based on the original cell values before scaling is applied. Therefore cell colors will not change with scaling.