Skip to Content
avatar image
Former Member

Display amount in US format

Hi Experts,

Can anyone provide solution for displaying the amount in US format?

Amount is displayed in 434638327.47, but it must display in 434,638,327.47 format.

thanks,

kavitha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 14, 2008 at 08:48 AM

    Hi Kavitha,

    try using this...

    CONVERT_TO_FOREIGN_CURRENCY Convert local currency to foreign currency.

    CONVERT_TO_LOCAL_CURRENCY Convert from foreign currency to local currency

    Regards,

    Vamshi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2008 at 07:29 AM

    Hi,

    goto to system->user profile->own data goto tab defaults

    and change decimal notation there

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 14, 2008 at 07:30 AM

    hi Kavitha,

    go to

    system->user profile->own data...in that defaults tab ...

    decimal notation jst select the format...

    regards,

    Vamshi

    Add comment
    10|10000 characters needed characters exceeded

    • if this problem is in forms than you may use command:

      SET COUNTRY 'US'.

      else for report you may write the amount field with currency like

      Write value to value1 currency 'USD'.

      SET COUNTRY 'US'. you can use in report also.

  • avatar image
    Former Member
    Oct 14, 2008 at 08:18 AM

    Hi Kavitha,

    Just go through the following link:

    convert-amount-into-us-format

    Hope this will help.

    Regards,

    Nitin.

    Add comment
    10|10000 characters needed characters exceeded