Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

total in smartforms

Former Member
0 Kudos
2,535

hi,

how can i get the total of a field in a smartform?

7 REPLIES 7

Former Member
0 Kudos
334

Hi,

In ur driver programm loop into ur internal table....add the amt into variable total

an pass this variable to ur smartform..

0 Kudos
334

dont we have any option other than this..........like we cant get the total of a field directly in a smartform?

Former Member
0 Kudos
334

It is simple. There are some standard functions available in the smartform itself.

Just explore it. U can easily find out that.

Former Member
0 Kudos
334

hi,

if u want total of table field then u can do that in the table node.

In the table node there is a tab called Calculations in that specify operation as Total and souce and target field. Print the target field which contains the total value.

Reward point if useful...

-Umesh

Former Member
0 Kudos
334

This is possible in the calculations tab.

if your table has fields MATNR and MENGE, and your totals go into W_MENGE

operand - SUM,

field name - MENGE

target field name - W_MENGE

time - after sorting

for field name - MATNR

reset - for sort criteria

for field name - MATNR

In your tab you'll need to fill the columns with,

operand - SUM,

field name - the field holding the quantity

target field name - the working field you need to hold the total

time - after sorting

for field name - the material no fieldname

reset - for sort criteria

for field name - the field name of your material number

Regards

vasu

Former Member
0 Kudos
334

Hi deepthi

1.create variable as total in global definitions

2.at table , Tab :Data , entry field (example carrid(total in carrid)) that you want total

3. tab : calcalution : entry data like this

Operation Field name Target Field Time

Total wa-distance total After loop.

Remarks wa-distance is value that you want to sum for total.

Regards

Wiboon

former_member196280
Active Contributor
0 Kudos
334

Try this

if you're using 4.7 (or greater rel.) Lower version <b>EVENT tabs</b> .

Go to CALCULATIONS TAB: <b>in table</b>

Insert a row like this:

Operation : SUM TOTAL

Field name: the field with value you want to calculate the total;

Target : the name of variable where total has to be stored;

Time : A After looping

In this way the system automatically calculate the total.

In the footer section insert a text node where the variable of TARGET is printed

Regards,

SaiRam