alv_grid total problem

[Former Member]

Hi experts,

my problem in the alv grid is when i subtract the amount its coming diffrent.

like 221,397,000 - 1,000 = 221,396,000 but here its coming it as 22,139,699,000. as its subtracting by (dot) .1000 . so wat might b the problem & hw to change it.

Regards

Sunita.

[Former Member]

Hi Sunitha,

Move both the values in the char fileds and try to substract and then again move the final value to the amount filed.

hope it works.

Thanks!

[Sandeep_Panghal]

Check the user settings for displaying amount fields in SU01

[Former Member]

hi sunita

you cn go thru dis documentation

http://help.sap.com/saphelp_nw04/helpdata/en/fa/efb52cf8a611d2b48d006094192fe3/frameset.htm

hope this helps

regards

Aakash Banga

[former_member585060]

Goto Menu>System>UserProfile>Owndata

Defaults Tab

Look for Decimal notation

Change the decimal notation here

[Former Member]

Hi,

Try like this :

Remove all thousand separators and subtract it. Again move the value into the required field.

To remove seperators First Replace all thousand seperators with Spaces then Condese without Gap the value. then subtract value. Again place the seperators as per your settings in SU01.