February 4, 2007 at 10:52 pm
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?
February 5, 2007 at 5:47 am
You could sum your amounts and then divide by the distinct count of months in your result set.
February 5, 2007 at 2:43 pm
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!
February 6, 2007 at 12:28 pm
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.
February 6, 2007 at 2:51 pm
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