Sum Table Aggregate Column in footer

[vlad]

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

[Stef]

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