Display amount in US format

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

Hi Kavitha,

Just go through the following link:

Hope this will help.

Regards,

Nitin.

[Former Member]

hi Kavitha,

go to

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

decimal notation jst select the format...

regards,

Vamshi

[Former Member]

In user profile, decimal notation is already in the same format.

but still awaiting for solution

[former_member181995]

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.

[Former Member]

Hi,

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

and change decimal notation there

Regards,

Amit