Customizing a Metric Number Format

You can create a custom format syntax for metric values to be displayed on the report. Following are some examples of common customized formatting you can apply to a metric:

• Cut off decimal numbers automatically after a certain number of digits, or truncate the leading zero in a decimal so that 0.2 becomes .2.
• Align decimals down a column, rather than left-aligning or right-aligning.
• Include strings that always appear with the calculated value, such as this month, sales=, or Customer no..
• Provide a specialized date or time format, such as Feb 3, 06 or 01h 32m.

To create a custom metric format

1. In MicroStrategy Web, click the metric you want to format. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric that you chose to edit.
2. Click the Format icon. The Format dialog box opens.
3. Select the area of the metric to format by selecting one of the following from the drop-down list at the top left:

• To format the metric column headers (the titles), select Metric Headers.
• To format the metric values (the numbers calculated by the metric), select Metric Values.

4. From the list of categories on the left, select Number.
5. Select Custom.
6. Enter your custom format syntax in the Custom field. See the Advanced Reporting Guide for a table of formatting symbols you can use and examples you can replicate.
7. Click OK to save your settings and close the Format dialog box.
8. Click Save to save the metric with your custom format. A confirmation message displays.
9. Click OK to close the Metric Editor.