I have a calculated field that is displaying only a number. I want to force a "$" to the front of it. In Designer I select "Show Currency and Unit" but it adds the $ to the end which is inconsistent with the rest of the report.
What is the best method to do this?