Method Community

 

Formatting a Label

Last post 04-22-2015 12:40 PM by Method_Audisho. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-22-2015 12:13 PM

    Formatting a Label

    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.

  • 04-22-2015 12:40 PM In reply to

    Re: Formatting a Label

    Answer

    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

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)