topic total in smartforms in Application Development and Automation Discussions

total in smartforms

Former Member — Wed, 19 Sep 2007 09:21:08 GMT

hi,

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

Re: total in smartforms

Former Member — Wed, 19 Sep 2007 09:22:53 GMT

Hi,

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

an pass this variable to ur smartform..

Re: total in smartforms

Former Member — Wed, 19 Sep 2007 09:24:27 GMT

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

Just explore it. U can easily find out that.

Re: total in smartforms

Former Member — Wed, 19 Sep 2007 09:24:51 GMT

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

Re: total in smartforms

Former Member — Wed, 19 Sep 2007 09:25:06 GMT

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

Re: total in smartforms

Former Member — Wed, 19 Sep 2007 09:27:59 GMT

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

Re: total in smartforms

Former Member — Wed, 19 Sep 2007 09:30:25 GMT

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

Re: total in smartforms

former_member196280 — Wed, 19 Sep 2007 09:50:46 GMT

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