KB11518: How to change the display and formatting of metric or attribute values for MicroStrategy Developer reports

Strategy users can format how the values of metrics and attributes are displayed on their reports. To make these formatting changes, right-click the attribute or metric name > Formatting > Values > Custom under the "Number" tab.
 
Enter the formula to change the display, as shown in the screen shot below:

 
Any formatting allowed for a cell in Microsoft Excel can be used with Strategy to format a value displayed on a report.
 
To find other formats that can be used with Strategy:

• Open an Excel worksheet.
• Right-click on a cell > Format Cells > Number tab and then select "Custom," as shown below:
  

• An existing expression can be used or a new valid expression can be written.