topic Re: select sum( column1 ) + sum( column2 ) as 'sum'... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442994#M1551923 <HTML><HEAD></HEAD><BODY><P>Unfortunately it dosent work, like we do column addition as in excel between two columns(of integers ). </P><P></P><P>Process the logic in loop .</P></BODY></HTML> Wed, 15 Dec 2010 11:14:45 GMT Former Member 2010-12-15T11:14:45Z select sum( column1 ) + sum( column2 ) as 'sum'... https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442993#M1551922 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i'm trying to make something like </P><P></P><P><STRONG>select sum( column1 ) + sum( column2 ) as 'sum'</STRONG></P><P> </P><P><STRONG>from mytab</STRONG></P><P><STRONG>into mysum</STRONG></P><P><STRONG>where ...</STRONG></P><P></P><P>in ABAP. </P><P>Any Ideas how this could work. Because the statement above does not work in ABAP</P><P></P><P>thanks</P><P>sven</P><P></P><P>Edited by: Sven Delangle on Dec 15, 2010 12:11 PM</P></BODY></HTML> Wed, 15 Dec 2010 11:09:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442993#M1551922 Former Member 2010-12-15T11:09:21Z Re: select sum( column1 ) + sum( column2 ) as 'sum'... https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442994#M1551923 <HTML><HEAD></HEAD><BODY><P>Unfortunately it dosent work, like we do column addition as in excel between two columns(of integers ). </P><P></P><P>Process the logic in loop .</P></BODY></HTML> Wed, 15 Dec 2010 11:14:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442994#M1551923 Former Member 2010-12-15T11:14:45Z Re: select sum( column1 ) + sum( column2 ) as 'sum'... https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442995#M1551924 <HTML><HEAD></HEAD><BODY><P>sum each column into a separate variable, add the two together at the end of SELECT.</P></BODY></HTML> Wed, 15 Dec 2010 12:32:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-sum-column1-sum-column2-as-sum/m-p/7442995#M1551924 Former Member 2010-12-15T12:32:48Z