KB47064: In MicroStrategy Developer, using the German syntax "#." to format numbers to displays thousands does not work

Symptoms

When trying to edit a metrics number format, the syntax to display the number in thousands is "#,". When using the locale regional German syntax "#.", the formatting is not applied.
 
 

Steps to reproduce

Formatting is NOT applied as expected.

• When using English regional settings:
  
• Set the Windows OS regional settings to English (US) and Strategy Developer language to English
  

• Log into Strategy Developer and create a report with Category and Unites Sold, run the report
• Right mouse click on Units Sold and go to Formatting > Units Sold values
  

•  on the Number tab, select Custom
•  type: #, (This is the English syntax to display in thousands)
  

•  click OK
  

• Formatting is applied as expected.
   
  
• When using German regional settings :
  
• set the Windows OS regional settings to German (Germany) and Strategy Developer language to German
• log into Strategy Developer and create a report with Category and Unites Sold, run the report
• Right mouse click on Units Sold and go to Formatting > Units Sold values (Formatierung > Units Sold Werte)
• on the Number tab, select Custom (Zahl > Individuell)
• type: #. (This is the German syntax to display in thousands) 
  

• click OK
  

Cause

The syntax is hard coded and is the same for all languages.
 

Action

Use the syntax for English language as described in TN 16876 How to customize a metric's format using syntax in MicroStrategy Desktop 9.x and newer