Calculating Averages
Good afternoon John,
I tried the other formula once again and it returned a value; it added
instead of averaging. Also, when i enter NA, it does not return a value at
all, it simply goes blank.
I apologize for the inconvinience and do appreicate your help with this.
What can i do to get it to Average instead of adding and to factor in the NA
in order to set it to Null.
--
Rene Lazaro
"John Spencer" wrote:
Sorry, but I can't see why you are getting error returned. You might try
Avg(IIF(IsNumeric([Score A],Val[Score A],Null))
Does that work to return a value? If so, then try adding the other parts
one at a time and see if they work.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
"Rene Hernandez" wrote in message
...
Good morning John,
I tried that but it gave me #error. I thought i might've been doing
something wrong.
Other suggestions.
I appreciate your help. Await your response.
--
Rene Lazaro
"John Spencer" wrote:
Avg(IIF([Score A] = "NA",Null, Val([Score A]))) +
Avg(IIF([Score B] = "NA",Null, Val([Score B]))) +
Avg(IIF([Score C] = "NA",Null, Val([Score C]))) + ...
I am not sure why you are adding the averages but if that is what you
want to do then this will work.
If you want the average score for A and the average score for B then you
need to do the calculation in separate fields.n
'================================================= ===
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'================================================= ===
Rene Hernandez wrote:
How would i include [Score B], [Score C], etc.
Thanks.
|