Sapscript - Field type KWERT should have thousand seperator but doesn't

[Former Member]

Hi,

I have a field declared as type kwert in print program. When I debug the program and sapscript it shows as 73849505.91 and also when it prints out it also shows as 73849505.91. However this should be 73,849,505.91.

My user settings are correct and so are the country settings in config.

Any help greatly appreciated.

[former_member196280]

Declare a variable type P.

Ex: data : amount type p decimals 2.

Move KWERT to amount. " it wiwll automatically places , notation.

Reward points if useful.

Regards,

SaiRam

[Former Member]

Hi,

Thank you. I have tried with &VAL(T)& but it doesn't put in the thousand seperator. According to my search the '(T)' actually removes the seperators?

[former_member196280]

See whether any modifications done in your driver program, like changing it to character field and removing commas.

If not try this in SAPSCRIPT

&<FIELDNAME>(T)&

Regards,

SaiRam

[Former Member]

Hi,

You need to write the field in script like below

&FIELD(T)& " thousand Separator

Regards

Sudheer