topic Re: Decimals format in scripts in Application Development and Automation Discussions

Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:04:01 GMT

Hi all,

I have a scripts in which the currency values are getting displayed in the format 123.456.78,910 whereas I need the format 123,456,78.910

I've set the defaults in SU3 to meet this requirement, but its not working. I even checked the values in print program in debug mode & its fine there.

I have given the additional (I) to that field in scripts so that it shouldn't print 0 if there's no value.

Kindly suggest me any standard method/setting to solve this.

Re: Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:31:15 GMT

Hi,

Please give (T) to that field in the script and check the output. T is for thousands.

Regards,

Venkatesan.

Re: Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:33:20 GMT

after changing the defaults in SU3, i think we need to log-off and log-in again for the changes to reflect.

pls check it...

thx

pavan

Re: Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:35:32 GMT

try with that

(c.3) or (i.3).

it may work but not sure

regards

shiba dutta

Re: Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:36:18 GMT

Hi,

Set country is the command in sapscript influences the decimal format.

set country as US, it will resolve your problem.

Thanks

Re: Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:38:21 GMT

Hi Jithendra,

Try to comply the format according to the country code. It should solve your problem.

Cheers,

Patrick

Re: Decimals format in scripts

Former Member — Wed, 20 Dec 2006 07:41:44 GMT

hi,

Omitting the Separator for ‘Thousands’ Symbols of the DEC, CURR, INT, and QUAN data types are normally formatted with the a ‘thousands’ separator character.

The T option allows you to omit this separator character. Syntax: &symbol(T)&

use this syntax .

use set country for country specific format and then adjust the currency setting currency format.

U have to go for that option

why dont u move this values into aa character variable and see the same as already u mentioned it that in debugging values are fine .

regards,

vijay

Re: Decimals format in scripts

Former Member — Fri, 19 Jan 2007 23:03:13 GMT

hi Jitendra

Could you please tell me how you got the solution for your problem. I have a similar kind of requirement where in i had to display 1,22.00 for a french script and 1.22,00 for an english script.

Anticipating your reply