KB42278: In MicroStrategy 9.x, using custom number format #.#0 to limit decimal places displays as expected in MicroStrategy Desktop, but not in MicroStrategy Web.

SYMPTOM:
Users notice when using the following custom number formatting, to reduce values to two places after the decimal, append 'K' to values greater than one thousand  and 'M' to values greater than one million, that the format is only displayed as expected in Strategy Developer.
 
#.#0,,"M";#.#0,"K";0
 
 
STEPS TO REPRODUCE:

•  In Strategy Tutorial, create a report with Year, Region and Revenue.
  

• Right click on Revenue. Choose 'Formatting' > 'Revenue Values'.
  

• Set the custom number format as above.
  

• Notice the values appear as expected in Developer.
  

• View the report in Web. Notice the values are not formatted as expected.
  

CAUSE:
 This behavior is expected in Strategy Web 9.x. The custom format is defined incorrectly.
 
ACTION:
Use the following custom format definition
 
0.00,,"M";0.00,"K";0