Formatting Data

Conditional Formatting

Enables conditional formatting of dimension member selections based on the criteria defined in the operand drop-down list and value text box.

Replace Missing With

Enables you to replace missing data with zeros or text that you specify.

Leading and Trailing Formatting

Currency Symbol

Inserts currency formatting symbols into the Positive Prefix and Negative Prefix text boxes.

Positive Prefix

Specifies the character to precede positive numeric values.

Positive Suffix

Specifies the character to follow positive numeric values.

Negative Prefix

Specifies the character to precede negative numeric values. Caution: The minus sign (-) is the default prefix. Deleting the default prefix without replacing it displays negative values as positive.

Negative Suffix

Specifies the character to follow negative numeric values.

Numeric Formatting

Grouped Thousands

Displays numeric digits as grouped by thousands.

Minimum Decimals

Indicates the minimum number of decimal places displayed.

Maximum Decimals

Indicates the maximum number of decimal places displayed.

Scale

Enables abbreviated values by tens, hundreds, thousands, ten-thousands, hundred-thousands, millions, and billions.

Use Negative Color

Indicates that negative numbers are signified by a selected color.

Select Negative Color

Enables you to select the color representing negative values.

Date Formatting

Select a date format.

Samples

Update Samples

Updates the samples panel based on the most recent formatting selections.