Skip to Content
avatar image
Former Member

Sum row in table form

Hello VC-Experts,

we are using VC 7.0 SP16. Is it possible to append a summary line in a table form for e.g. sum row for price column? I have trying the "SIGMA" operator but it is showing just the sum row in table and not the other rows.

Has anybody an idea how to handle is issue?

Thank you very much in advance.

Kind regards

Axel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 11, 2008 at 06:48 AM

    Hi Alex,

    If you are using BI queries in VC, then enable the result row in query so that the result row in this table will appear automatically.

    Else if you want to do some thing directly in VC model, then you can not achieve it directly you need to do some workaround using the same 'SIGMA' operator.

    Workaround:

    1. Drag a form window.

    2. Drag a 'SIGMA' operator

    3. Drag the dataflow from outport of query to input port of 'SIGMA' operator

    4. In SIGMA do summation of the KF you wanted

    5. Drag dataflow from output port of SIGMA to form

    6. Enable only the KF field for which you want summation

    7. Hide the label and place this form window below the table.

    It is not possible to do the summation in the table.

    Regards,

    Chandrasekar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Chandrasekar,

      thank you very much for your answer.

      we are using a ERP BADI to get a Internal Table as result. To get a summation row in the Visual Composer we are doing it now like the good old school ABAP way.

      - Calculate the sum in ABAP

      - Append the sum row to the export table

      - In Visual Composer create for each field an expression box and change the background color in style tab.

      Unfortunaly the visual Composer Table is not an ALV-Grid. Maybe in the next releases.

      However, thank you very much again, regarding 10 points.

      Kind regards

      Axel