ALV Total twice amount it should be
Hi,
I have specified the following entry in fieldcat table for use alv grid call function........
clear ls_fieldcat.
ls_fieldcat-fieldname = 'TOT_VALUE'.
ls_fieldcat-outputlen = 20.
ls_fieldcat-reptext_ddic = 'Credit Value'.
ls_fieldcat-do_sum = 'X'.
ls_fieldcat-datatype = 'CURR'.
append ls_fieldcat to p_fieldcat.
However, when I run the report for 1 record only, the value for this column in the grand total line of ALV grid is exactly twice the amount in the 'detail line' column. I have not specified a sort. I have done this successfully 100's of times without this result - so have no idea what is happening here?
Any help much appreciated.
R.
I found out the problem with this - stupidly, I had created 2 entries for the same field name in the fieldcat. Doh.