03-26-2009 6:44 AM
Hi ,
I have one column in ALV which has color red or green based on the whether to consider it in summationn or not based on some condition. Now I want to do 'Total' of this column, but not all the values should be considered. Instead of that only those values which have color green should be considered. Whether it is possible by capturing the do sum event or something like that? If yes, Please tell me the steps
Thanks in advance,
Rgds,
Madhuri
03-26-2009 6:52 AM
Use the filter to have only the positive values in your list. And then use the sum.
03-26-2009 7:14 AM
Hi,
I need to show all the values for user to cross check on which values have been considered for the summation in the summary report.
Rgds,
Madhuri
03-26-2009 9:18 AM
03-26-2009 6:56 AM
Hi,
Try this :
IT_FIELDCAT-DATATYPE = 'CURR' .
IT_FIELDCAT-CFIELDNAME = 'WAERS' " internal table field.
IT_FIELDCAT-CTABNAME = 'IT_TAB'. " internal table name
IT_FIELDCAT-FIELDNAME = 'NETPR'." internal table of nettpr field
IT_FIELDCAT-DO_SUM = 'X'.
Regards,
Prashant
04-10-2009 6:42 AM