topic Re: adding commas in quan variable of smartforms in Application Development and Automation Discussions

adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:00:05 GMT

hi experts,

In my smartforms,i have a variable temp_menge which is having value 1000000 but i want to get it displayed as 1,000,000.How to write the same.?????

Thanks,

Gaurav

Edited by: Gaurav Kumar on Feb 26, 2008 2:30 PM

Re: adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:03:07 GMT

Hi,

might be the variable temp_menge has been declared as charater field in your smartform/program. check it and declare the variable temp_menge as menge_d. then your problem will be get solved.

Re: adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:07:06 GMT

hi,

that variable is of type menge_d.

I'll explan:

data : temp1(50).

temp1 is having 1000000.

now when i assign it to variable temp_menge it does not take it in with commas rather it takes as it is from char variable, i want it to displayed like 1,000,000 .

Thanks,

Gaurav

Re: adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:07:17 GMT

Hi,

There might be 2 possibilities. One is data type. 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)&

The EKPO-MENGE field contains the value 1234.56. The Dictionary definition specifies 3 decimal places and an output length of 17.

&EKPO-MENGE& -> 1,234.560

&EKPO-MENGE(T)& -> 1234.560

So one thing is change your data type to TYPE P or remove the (T) from your code. This should work.

Reward points if helps.

Regards,

JLN

Re: adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:11:59 GMT

Hi,

check in your smartforms....

&temp_menge(t)& -> 1000000

&temp_menge& -> 1,000,000

Re: adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:30:57 GMT

hi all,

actually it is sapscript not smartforms.

Gaurav

Re: adding commas in quan variable of smartforms

Former Member — Tue, 26 Feb 2008 09:32:34 GMT

Gentlemen,

It will work for both scripts & smartforms.

Regards,

JLN

Re: adding commas in quan variable of smartforms

Former Member — Wed, 27 Feb 2008 03:57:20 GMT

Gentleman,

Its not working...

Thanks,

Gaurav