Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

do sum in ALV based on the color of the column

Madhurivs23
Participant
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

Use the filter to have only the positive values in your list. And then use the sum.

0 Kudos

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

0 Kudos

Is there any solution to this?

Former Member
0 Kudos

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

Madhurivs23
Participant
0 Kudos

no response. have to find out by myself