Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    8

    Unanswered: How to sum fields horizontal

    Hello,
    I need to sum several fields horizontal, see example.

    Location Appeal 1 Appeal 2 Appeal 3 Total
    Boston 350.00 650.00 150.00 $1,150

    How can I populate total on end.......going across. Inserting sub totals, totals only deal with going down. Is this a formula Sum(fields+fields), a running total formula? I've been searching the internet and my books for help.

    Thanks so much for any insight.

    Maximus2004

  2. #2
    Join Date
    Apr 2003
    Posts
    54
    Hi,
    I did that with the running total feature. I did not have any other solution.
    Also, with running total, you have to choose the database field from the body of the report and then specify the formula for the operation.

    Hope this helps.........

    Regards

    Jaideep

  3. #3
    Join Date
    Mar 2004
    Location
    Asia Pacific
    Posts
    14
    I tried that using a cross tab. You just have to insert a cross tab under insert menu then the wizard will guide you through.

Posting Permissions

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