I'm lazy. When it comes to programming, sometimes that's good and sometimes it makes a mess. Below is a script
'$'+PARSENAME(CONVERT(varchar,CONVERT(money,sum(yourColumnName)), 1),2) ParseName function got rid of my trailing zero's. the rest explains itself.