Page 1 of 1

Aggregate or sum of a column

PostPosted: Tue Sep 09, 2014 3:24 pm
by sanamir
Dear All,

I created PO report and want to sum up all rows of net Value column to get the total value of PO.

Example: A PO have 3 items of value like 100,100,50 i need these three values sum which is = 250.
how can i achieve this sum=250 in smart form.

Thanks
sanamir.

Re: Aggregate or sum of a column

PostPosted: Wed Sep 10, 2014 3:27 am
by Gothmog
(moved from ABAP)

In Smartforms? Be it in a table or a loop, you can use the Calculations tab to sum up a field.

Re: Aggregate or sum of a column

PostPosted: Wed Sep 10, 2014 10:51 am
by sanamir
Thanks Gothmog for your reply,

i want to show the sum of all values in column named NETWR in smartform

in DATA tab of table lines (LOOPS)
internal table [IT_EKPO INTO WA-EKPO]

So i need sum of WA_EKPO-NETWR field of work area.

i checked the calculation tab but did not understand how to get the desire results.

could you please elaborate a little bit more AND how to show result in smartform.

thanks