Urgent:page wise total in smartforms

[Former Member]

hi,all

How to do page wise total in smartforms ?

use table in smartforms for summary in pagebreak

ex. page1

10 (line 1)

20 (line 2)

30 (line 3)

total 100

page 2

40 (line 1)

50 (line 2)

total 50

Total in page 1 incorrect = line1(page1) + line2(page1) + line3(page1) + line1 (in page2)

Total in page 2 inccorrect = line2 (in page2) .

please help me guys to solve this problem..

[Former Member · Accepted solution]

r u printing the internal table data using the TABLE node then--> in the Calculation tab u can do this.

first create a variable in Global difinations-->global data tab.(ex v_tot)

then in the TABLE>calculations TAB> 1select ->sum then 2nd colun>give the field name which u want to calculate (ex-wa_itab-netwr) in the Target Filedname tab> give the varialbe u have declared for the total(ex v_tot). in TIME colums select AFTER theLOOP...

then in theTABLE>footer>inset a line display the variable(total u r using).here

after the the printing the total..->create a program lines> cleat the v_tot... why u need to clear this is.... u want to display only the total value which are displaying in the current page... after printing this v_tot... clear this... so that in the next page it start totaling the freshly...

lem me know if u have any clarifications.

u can calculate as the above way for all the 6 fields.

please Avoid postin duplicate threads

[Former Member]

Hi,

hi this link will solve ur problem, award points if found helpful

https://forums.sdn.sap.com/click.jspa?searchID=397836&messageID=317002

https://forums.sdn.sap.com/click.jspa?searchID=485135&messageID=1405177

Regards

Sudheer

[Former Member]

Hi Edgar,

In table element we had events like AT the end and so on.

otherewise u can insert a command line in the table and if the

form page is changed u can display the amount at the end of the

page or footer.

Reward if usefull.

regards,

Sunil