SSRS Format Expression for Millions

Josh,

So you want to display a number in millions (i.e. $2,123,456 as $2.12) on an SSRS report, perhaps as a data label on a chart.

Here is the format expression to do so as well as for Thousands and Billions.

For Millions:

  $#,,.00  

For Thousands:

  $#,.00  

For Billions:

  $#,,,.00  

Thanks to:  http://social.msdn.microsoft.com/Forums/en-US/b81e51c6-c494-410e-9a8a-2012d35ff5de/values-to-be-shown-in-thousands-millions-and-billions-in-report-builder-20?forum=sqlreportingservices