KB19240: Metric values with fixed format are exported to Excel with custom format in MicroStrategy Developer 9.x

SYMPTOM:
Metric values with fixed format in Strategy Developer  9.x are exported to Excel with custom format.
 
STEPS TO REPRODUCE:
Follow the steps below to reproduce the issue using the Strategy Tutorial project:
 

• Create a copy of the Revenue metric and change its formatting to 'Fixed' with 0 decimal places. Save it as 'Revenue Fixed Format'.
• Create a report with Year attribute in the rows, and the Revenue Fixed Format metric in the columns. Execute the report.
  

• Export it to Microsoft Excel.
• Right-click on any of the metric data cells and go to Format Cells. The formatting is displayed as Custom #,##0;(#,##0).
  

• Note: The metric display in the Excel file is the same as in the report. However, calculations performed on the data in Excel do not take into consideration the fixed format.
   
  

CAUSE:
This is a known issue with Strategy Developer 9.x.
 
ACTION:
 
This issue was fixed in Strategy  10.3.