Ever needed to make a calculated measure have a display type of “Currency”? Did you notice it wasn’t what you wanted?
Instead of choosing the drop-down box to “Currency”, you can type in your own. You’ll notice that “#,#.00″ is nearly what we want, but we need to add a “$”. To finish up, you can type in “$#,#.00″. Don’t forget to include the quotes just like the other ones. If you’d like to get rid of the decimals, feel free to omit the .00 and just type in “$#,#”.
Posted by Mark Garner 
