2010 Dec 15 11:09 AM
Hi,
i'm trying to make something like
select sum( column1 ) + sum( column2 ) as 'sum'
from mytab
into mysum
where ...
in ABAP.
Any Ideas how this could work. Because the statement above does not work in ABAP
thanks
sven
Edited by: Sven Delangle on Dec 15, 2010 12:11 PM
2010 Dec 15 11:14 AM
Unfortunately it dosent work, like we do column addition as in excel between two columns(of integers ).
Process the logic in loop .
Hi,
i'm trying to make something like
select sum( column1 ) + sum( column2 ) as 'sum'
from mytab
into mysum
where ...
in ABAP.
Any Ideas how this could work. Because the statement above does not work in ABAP
thanks
sven
Edited by: Sven Delangle on Dec 15, 2010 12:11 PM
2010 Dec 15 11:14 AM
Unfortunately it dosent work, like we do column addition as in excel between two columns(of integers ).
Process the logic in loop .
2010 Dec 15 12:32 PM
sum each column into a separate variable, add the two together at the end of SELECT.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |