K
KingsWay
Okay, here's the situation. I was getting no value on my expression for
averaging 52 separate fields. With the help of everyone here, I figured out
the problem. If one of the fields in the equation is null, it won't perform
the query.
This is the new problem. I am averaging attendance records, so, if a week
hasn't come yet, the value is "0". However, this affects the average
adversely. Is there a way to average based on the values that have been
collected?
Here's the equations I have:
sum1:
([wk1])+([wk2])+([wk3])+([wk4])+([wk5])+([wk6])+([wk7])+([wk8])+([wk9])+([wk10]+([wk11])+([wk12])+([wk13])+([wk14])+([wk15]))
average1: [sum1]/52
I guess I'm hoping there's a way for the database to figure out the number
to divide by based on the number of weeks that have value and not use the
"52".
Any thoughts??
Michaela
averaging 52 separate fields. With the help of everyone here, I figured out
the problem. If one of the fields in the equation is null, it won't perform
the query.
This is the new problem. I am averaging attendance records, so, if a week
hasn't come yet, the value is "0". However, this affects the average
adversely. Is there a way to average based on the values that have been
collected?
Here's the equations I have:
sum1:
([wk1])+([wk2])+([wk3])+([wk4])+([wk5])+([wk6])+([wk7])+([wk8])+([wk9])+([wk10]+([wk11])+([wk12])+([wk13])+([wk14])+([wk15]))
average1: [sum1]/52
I guess I'm hoping there's a way for the database to figure out the number
to divide by based on the number of weeks that have value and not use the
"52".
Any thoughts??
Michaela