Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Summing a calculated field on a report footer?

    I have a calculated field:

    If "territory 1" is > 900 then the "premium" is the difference (otherwise "0"). In the report footer I need to sum whatever comes up in the "premium" column. Problem is, no summing of calculated fields... I tried using the "Running Sum" property but of course that doesn't work and I can't get the same outcome with the totals of the other fields in the footer. If anyone has some tips on getting around this I would GREATLY appreciate it.

    Thanks.

  2. #2
    New Lounger
    Join Date
    Sep 2006
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Summing a calculated field on a report footer?

    In case anyone runs across this problem, I found the answer on MSDN - Article # Q208850. The second case solved this dilemma with a little bit of tweaking.

Posting Permissions

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