Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Location
    UK
    Posts
    160

    Unanswered: Calculating Sum of Category Sum to create grand total

    Hi there,

    I have a subreport grouped on a category. In the category footer I have an equation =Sum([Extended_Price])

    Still within the same subreport I would like to add up all the results of the =Sum([Extended_price]) to create a grand total.

    I've been messing around with running sum and searching the forum/google on how to do this but I keep getting it wrong.

    Could someone help me with the expression please?
    i thank you :-)
    marcus

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    IIRC, just stick a textbox with exactly the same expression in the report footer.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Sep 2010
    Location
    UK
    Posts
    160
    yup! that did it. thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •