try
"$" + String (JobAsmbl.TotalCost)
(or whatever your field is) as a formula for a calculated field. It's not a numeric field- it has to be a character field, and make sure your numeric field is formatted so that it will print as you require.
If you are going to use it in a BAQ report, it would probably be better to format the field in the report. To format a dashboard would be a customization.
Hope this helps!
- leAnn
"$" + String (JobAsmbl.TotalCost)
(or whatever your field is) as a formula for a calculated field. It's not a numeric field- it has to be a character field, and make sure your numeric field is formatted so that it will print as you require.
If you are going to use it in a BAQ report, it would probably be better to format the field in the report. To format a dashboard would be a customization.
Hope this helps!
- leAnn
--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> Won't that align left instead of right?
>
> Patrick
>
> On Apr 11, 2013, at 4:02 PM, "Rob Bucek" <rbucek@...> wrote:
>
> Calculated character field using concatenation?
>
> Sent from my Verizon Wireless 4G LTE DROID
>
>
> "Winter, Patrick" <pjw@...> wrote:
>
>
>
> All,
>
> How do you display a $ sign in a Dashboard in front of a integer or
> decimal field?
>
> Patrick Winter
> Information Technology Manager
> Specialty Screw Corporation
> 2801 Huffman Boulevard, Rockford IL 61103
>
> Vantage 6.10.514, Progress 9.1D
> Testing: Epicor 9.05.700c, Progress Database, Windows Server 2008 R2
> Standard
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>