Average Function Help

  • I have a Reporting Services 2000 report that I need an average field on, I know of the AVG function, but Im having trouble with some of the grouping.

    My report is like this:

    Jan

    User Type 1 -- 345

    User Type 2 -- 123

    User Type 3 -- 333

    Total -- 801

    Feb

    User Type 1 -- 654

    User Type 2 -- 412

    User Type 3 -- 443

    Total -- 1509

    The 'Total' row, is a calucated field using the SUM function and it is done on the group footer of the first group within the report table.

    I now have a table footer that I want the average of the totals of each month, so (801 + 1509) / 2. But I cannot do an AVG of a SUM function, so how do I get the AVG of the totals for each month?

  • You could sum your amounts and then divide by the distinct count of months in your result set.

  • very true, so If I have two input dates, how do I find the disinct number of months?

    I did try this approach, but found that I couldnt get the Expressions correct, any help would be greatly appreciated!

  • Whats the diffrence of the 2 sum divided by 2 and all six numbers divided by 6 . I think it is just a mater of scope and which group you apply the average to.

  • I have been messing around with groups and I cant get it to work, I only have a very basic table and it only has 1 group inside of it, so naturally I have tried that groups name in the scope parameter. But to no avail.

    You mentioned numbers like, "difference of the 2 sum divided by 2", where do I get the number two from? Is there a counting feature of some sort available in RS?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply