KB6295: How to format a metric so that it will be scaled down by thousands or millions in MicroStrategy Developer 9.x.

Perform the following steps to format a metric so that it will be scaled down by thousands or millions (i.e., be multiplied by thousands or millions).

1. Edit the metric to be formatted and then select 'Tools' > 'Formatting'.
2. Select the 'Custom' option in the 'Category' section and add in the following syntax:
   
1. To scale the format of metric down by 1000 (i.e., equal to dividing the metric by 1000):
   #,##0,.0;(#,##0,.0)
   
2. To scale the format of metric down by 1,000,000 (i.e., equal to dividing the metric by 1,000,000):
   #,##0.0,,;(#,##0.0,,)
   

 
For additional information on customizing metric formatting, please refer to the following technote:
 
KB16876 - How to customize a metric's format using syntax in MicroStrategy Desktop 9.x and newer