This website is not affiliated with, sponsored by, or approved by SAP AG.

Aggregate or sum of a column

Development SAPscript/ Smartforms

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Aggregate or sum of a column

Postby sanamir » Tue Sep 09, 2014 3:24 pm

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.
sanamir
 
Posts: 10
Joined: Thu Jul 03, 2014 2:23 pm

Re: Aggregate or sum of a column

Postby Gothmog » Wed Sep 10, 2014 3:27 am

(moved from ABAP)

In Smartforms? Be it in a table or a loop, you can use the Calculations tab to sum up a field.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1942
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Aggregate or sum of a column

Postby sanamir » Wed Sep 10, 2014 10:51 am

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
sanamir
 
Posts: 10
Joined: Thu Jul 03, 2014 2:23 pm


Return to SAPscript/Smartforms

Who is online

Users browsing this forum: No registered users and 4 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.