Sum Table Aggregate Column in footer

2 posts, 0 answers
  1. vlad
    vlad avatar
    21 posts
    Member since:
    Aug 2007

    Posted 12 Nov 2013 Link to this post

    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
  2. Stef
    Admin
    Stef avatar
    3053 posts

    Posted 15 Nov 2013 Link to this post

    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.

  3. DevCraft banner
Back to Top