Sum row in table form

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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