getting sum in grid..

[Former Member]

Hi all,

Iam displaying by grid using classes.

Requrement is to get the sum of a partcular column and i used the following code

to populate the fieldcat.

clear wa_fieldcat.

wa_fieldcat-fieldname = 'SUM'.

wa_fieldcat-do_sum = 'X'.

wa_fieldcat-inttype = 'P' .

wa_fieldcat-key = space.

wa_fieldcat-col_pos = v_f_count.

wa_fieldcat-coltext = ' Total Spend '.

append wa_fieldcat to i_fieldcat.

Iam getting the sum value but syntax is like 1.000,00 , 3.300,00

mean ',' in place of '.' .

please help me out.

[Former Member]

Hi,

Check the Amount formart selected in the Tcode SU01 userprofile.

[Former Member]

oops!

I dont have the authorization to run that tcode.

r u sure that problem is in the format only...

thanks,

Anil.

[Former Member]

Hi,

open any session and then system - User profile - own data.

it will open a new session where you can maintain the defaults, date formats, currency formats,

now go to defaults tab,

decimal notification field will be there. you can select the exact format there. and save it

Now run the program and see the o/p

Regards,

Venkatesh

[suredarreddy_pulimamidi]

Hi,

Check these settings.

SPRO->SAP Ref IMg->SAP Netweaver->General Settings->Define Contires In mySAP Systems

There find out the country from which the records are coming.

Check the decimal point format.

Regards,

Surendar Reddy.

[Former Member]

Thanks and I got good replies.

Problem solved.