Method Community

How can I format a number that is in a label found on a screen, NOT in a report.?  I have a label that contains daily sales, but looks like 2840.2300 and I would like it to look like $2,840.23.

Hi joshsAA,

Labels and text objects do not allow you to format the contained value in this manner. Most of the objects with dollar amounts on our screens are money fields that are stored in the table. These fields are formatted to 2 decimal places by default.

If you are using a basic math calculation action to obtain your daily sales value, the action allows you to specify the number of decimal places to round the result to. If you’re not already using a basic math calculation you can use one for just rounding your result: Add 0 and round to 2 decimal places.

As for displaying a dollar sign, just add another label to the left and set the caption to “$”. I hope this helps.

-Audisho