SQL, VB, MicroStrategy & Other Topics

Have you wanted to do this? Very easy to so  with version 9.x. Accessible from Project Configuration > Project Definition > Communications.

Ever come across a situation where you need more real estate on the chart but those large dollar amounts on your Y axis running in to hundreds of millions just take up all of the white space? Or simply make your grids too wide? Solution is very simple! Go to the metric number formatting, select Fixed  number format and change Abbreviation value to desired format - thousands, millions  or billions . Another option is to select Custom  number format and enter this formula:   #,##0,.00"K";(#,##0,.00)"K" Once this formula is working fine, modify it to suit your needs.