Former Member

# total in smartforms

hi,

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

##### Add a comment
10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Sep 19, 2007 at 09:22 AM

Hi,

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

an pass this variable to ur smartform..

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member

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

• Former Member
Posted on Sep 19, 2007 at 09:24 AM

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

Just explore it. U can easily find out that.

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member
Posted on Sep 19, 2007 at 09:25 AM

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

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member
Posted on Sep 19, 2007 at 09:27 AM

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

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member
Posted on Sep 19, 2007 at 09:30 AM

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

##### Add a comment
10|10000 characters needed characters exceeded
• Posted on Sep 19, 2007 at 09:50 AM

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

##### Add a comment
10|10000 characters needed characters exceeded