topic Re: getting sum in grid.. in Application Development and Automation Discussions

getting sum in grid..

Former Member — Fri, 27 Feb 2009 05:51:43 GMT

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.

Re: getting sum in grid..

Former Member — Fri, 27 Feb 2009 05:53:27 GMT

Hi,

Check the Amount formart selected in the Tcode SU01 userprofile.

Re: getting sum in grid..

Former Member — Fri, 27 Feb 2009 05:55:54 GMT

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

Re: getting sum in grid..

Former Member — Fri, 27 Feb 2009 05:56:42 GMT

oops!

I dont have the authorization to run that tcode.

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

thanks,

Anil.

Re: getting sum in grid..

suredarreddy_pulimamidi — Fri, 27 Feb 2009 05:59:55 GMT

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.

Re: getting sum in grid..

Former Member — Fri, 27 Feb 2009 06:12:19 GMT

Thanks and I got good replies.

Problem solved.