Formatting a Metric

For more information on Formatting a Metric, see https://doc-archives.microstrategy.com/producthelp/10.5/basicreporting/webhelp/lang_1033/content/basicreporting/Formatting_a_metric.htm#brcreatingquery_2014045409_1441316

Metrics can be formatted independently of the report(s) on which they appear. When you format a metric, you can format the metric’s column or row header, and you can also format the data that will appear for that metric.

You can apply special formatting to numeric values that appear when a metric is calculated, such as currency, percentages, and date format style. You can apply special font styles and sizes, and you can determine cell background colors or patterns. This formatting can help analysts more easily identify specific data. For example, you might have all sales data appear in a blue font, while profit data appears in a bold green font.

Metric formatting can be performed using either of the following interfaces:

• Metric Editor: Use this method to format one metric at a time. Formatting changes made using this method affect the metric no matter which report the metric is included on.
• Find and Replace feature: Use this method to format a number of metrics at one time with the same format.

For information about using the Find and Replace feature to format metrics, see the Advanced Reporting Guide. For specific steps to use the feature, as well as information on each option in the software, open the Find and Replace feature from Developer’s Tools menu, and then click Help.

For information to format metric data on a report so that the formatting applies to that report only.