Averaging excluding current

[neilgeurin2000]

Hi,

I have created a report that scores the results of Read, Click and Response Data which relates to a number of webpages my company uses. At the moment a query averages all of the available read rates, calculates percent increase/decrease of the individual read rate I am scoring and assigns a score using an if/then statement (e.g. if the percent change is 20% above average it assigns a score of 2).

What I need to do is find a way to exclude the read rate for any statement I am scoring from the original averages so as not to skew my score. Hope this makes sense. Does anyone know how best to go about doing that? Thanks in advance!

 

[dhookom]

Since you haven't gotten any replies yet, I assume others are as confused as I am. It would really help if you would type some sample records into a message and then how you expect the values to be calculated and displayed.

Duane
MS Access MVP

 

[neilgeurin2000]

I answered my own question this morning - sorry for the confusion. In case you are still curious here is what I did. This is the piece of the query I used to score webpage clicks:

I have a column that subtracts the number of clicks for a specific campaign from the total number of clicks all of our campaigns have received.

I have a second column that subtracts one from the count of total campaigns.

I then take the adjusted number of clicks divided by the adjusted number of campaigns to get the average number of clicks per campaign excluding the current.

I calculate a percent increase or decrease of the campaign I am analyzing's clicks from the new average and then I can give a "score."

Hope that makes some sense, if not sorry to waste your time. Thanks so much for giving it a shot, hopefully I will eventually get good enough at Access that I can actually describe the problems I run into! Thanks again!

Neil