This is a migrated thread and some comments may be shown as answers.

Sum Table Aggregate Column in footer

1 Answer 282 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
vlad
Top achievements
Rank 1
vlad asked on 12 Nov 2013, 07:40 PM
Hello,

Let's say I have a table with two columns defined as following:

ITEMS ON HAND
=Sum(Fields.transaction_units)

STOCK VALUE
=Fields.item_unit_cost * Sum(Fields.transaction_units)

What I want is to sum stock value in the table footer. I tried

=Sum(Fields.item_unit_cost * Sum(Fields.transaction_units))

but nested aggregates are not allowed. This is a quite common scenario, so I suppose that there is a simple way to achieve it?

Thanks

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 15 Nov 2013, 03:07 PM
Hello Vedran,

If the expression is in a detail row Sum(Fields.X) would return the same as Fields.X, and the total of the second column in your example would be Sum(Fields.item_unit_cost*Fields.transaction_units).

If you need further help, please elaborate on the Table item structure and the data organization and content. Feel free to send us these details in a support ticket.

Regards,
Stef
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

Tags
Report Designer (standalone)
Asked by
vlad
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or