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:
![]() |
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: |
![]() |
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. |
![]() |
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. |