Member formats

You can format dimension members in the dimension editor.

To apply the same format to all members of the dimension:

Open the dimension in the dimension editor.
Click the Attributes tab.
Right-click the Format column header.
Click Format values.
Click the format you want to apply to all the dimension members.

You can also apply a format to individual dimension members:

Open the dimension in the dimension editor.
Select one or more members to which you want to apply a format.
To select multiple adjacent members, click the first member, then SHIFT+click the last member.

To select multiple non-adjacent members, CTRL+click each member.
Click the Action icon on the edit dimension bar, then click Format values.
Click the format you want to apply to the selected dimension members.

You can choose from the following formats.

Note: The examples here use the actual value of -1234.567. The number changes based on the format used.

General: Displays numbers without commas to separate digits to the left of the decimal point. Negative values are prefixed with a minus sign (-).; -1234.57
Fixed: Displays numbers without commas to separate digits to the left of the decimal point. Negative values are surrounded by parentheses.; (1234.57)
Comma: Commas separate every third digit to the left of the decimal point.; (1,234.57)
Rounded: Commas separate every third digit to the left of the decimal point, rounded up to the nearest whole number. You can see the actual value by right-clicking in the cell.; (12,346)
Percentage: Multiplies numbers by 100 and displays a following percent sign (%). Digits to the left of the decimal point do not use commas, and negative values are prefixed with a minus sign (-).; -123456.70%
Scientific: Displays numbers in scientific notation. Scientific notation is a way of expressing large or small numbers. For example, the number 123,000,000,000 can be written as 1.23E+11.; Negative values are prefixed with a minus sign (-).; -1.2E+3
Accounting: Displays numbers with currency symbols and decimal points in a column. Negative values are surrounded by parentheses.; $(1,234.57)
Currency: Displays numbers with the currency symbol that is specified for your computer. Commas separate every third digit to the left of the decimal point. Negative values are surrounded by parentheses.; ($1,234.57)
Currency (rounded): Displays numbers with the currency symbol that is specified for your computer. Commas separate every third digit to the left of the decimal point, rounded up to the nearest whole number. You can see the actual value by right-clicking in the cell. Negative values are surrounded by parentheses.; ($1,235)
Date: Gives you a date picker, and displays dates in a predefined format: mm/dd/yyyy.; 01/23/1989
Time: Displays time in a predefined format: hh:mm:ss.; 12:30:00

You can also define custom formats.

Format examples

The following list shows the standard formats that are used in the dimension editor.

Note: d: means that ICU formatting is used. ICU is the standard format for IBM® Planning Analytics Workspace.

Fixed: d:0.00;(0.00)
Comma: d:#,##0.00;(#,##0.00)
Percentage: d:#.00%
Scientific: d:0.0E+0
Accounting: d:'$'#,##0.00;'$'(#,###.00)
Currency: d:'$'#,##0.00;('$'#,###.00)
Currency (rounded): d:'$'#,##0;('$'#,###)
Date: c:MM/dd/yyyy
Time: d:H:mm:ssICD

You can create custom formats by modifying these examples. To find out more about the syntax, see Custom character formats in Planning Analytics Workspace, Numeric value formats, and Date and time display formats.