Format Currency into millions of dollars SQL Server
17:27 07 May 2015

Can anyone help me format my dollars data into millions of dollars for SQL Server?

3,000,000

--> $3M

I have this but it's not working

SELECT     '$' + SUM(Sales_Information.Sales_in_Dollars / 1000000) 
                      AS [Sales in Millions]

Doing this gives me #Error

format(SUM(Sales_Information.Sales_in_Dollars / 1000000)
sql sql-server