Skip to Content
author's profile photo Former Member
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

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    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

  • author's profile photo Former Member
    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

  • author's profile photo Former Member
    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

  • author's profile photo Former Member
    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

  • author's profile photo Former Member
    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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.