topic Re: Number Format in Application Development and Automation Discussions

Number Format

Former Member — Sat, 24 May 2008 06:29:54 GMT

w_rwbtr is a character field.

Suppose the value of w_rwbtr is 1234567

I want to display it in the format

1,234,567.00

I was asked to try the below solution..

declare w_rwbtr1 as type P decimals 2.

move w_rwbtr to w_rwbtr 1.

again write ...

write w_rwbtr 1 to w_rwbtr.

It works but i do not get the comma separators.

It simply writes 1234567.00

but I want the comma separators as well. like

1,234,567.00

Re: Number Format

Former Member — Sat, 24 May 2008 06:35:27 GMT

Hi,

Declare one field to currency type and then try.

Also check the decimal Notation in user settings. ie. goto su01 > enter usename > click on display > deflut tab> check the Decimal Notation...If its not the one you want just change it.

REWARD IF USEFUL

Re: Number Format

geetha_k — Sat, 24 May 2008 06:37:50 GMT

Hi,

u will give the amount data type as CURR

check once this okk.

Re: Number Format

Former Member — Wed, 04 Jun 2008 06:17:59 GMT

thanks