Introduction

Applying Format Masks


Use format masks to apply the desired formatting to data values in the grid. Format masks apply to all the values for a dimension member. After a row or column member is selected, the formatting is applied to all data cells in that row or column. Format masks can only be applied through the right-click menu.

To apply format masks:

  1. Right-click on the row or column header.
    You can select multiple headers using Ctrl-Click or Shift-Click.
  2. Select Advanced > Format Mask....
    The Apply Format Mask dialog box appears. The members selected are displayed at the bottom of the dialog box.
  3. Click the Format type drop down list to view available masks. If you select a Custom format type, enter the mask in the Mask text box. An example of the mask appears below the Mask text box.
  4. Click OK to close the dialog box.
Note

To specify your own custom format, you can select the different Format types from the drop down list and see how the format specification works from the format mask automatically displayed underneath the drop down list. Copy a format that's closest to what you want and edit it. The commonly used symbols are:
# - stands for an optional digit
0 - stands for a required digit
$ - adds a "$" sign
'%' - adds a "%" sign (enclosed it in single quotes)

Note

Be sure to verify the changes by viewing the Example before applying the format mask. When applying custom format masks, it is possible to enter masks that cannot be implemented and may result in no data appearing in the grid.

Note

If you have multiple format masks with overlapping scopes, you can set the order these format masks should be applied by choosing Tools > Manage > Format Masks... from the menu bar. This Manage Format Masks... dialog also lets you edit or delete a format mask.


Related Topics: