From: "pravin" <pravinn@stripped>
> SRNO EMP_ID DATETIME QUES1 QUES2 QUES3 QUES4 QUES5 QUES6 QUES7 QUES8
> I now want to show a report from this table.This report will be group by
> So the main problem is for calculating average of QUES3 for EMP_ID=10.
> This average is calculating without considering NA records. So for QUES3
> answers are 4,NA,2 so the average will be 6/2 and not 6/3.
The easiest solution to this problem altogether is to modify the database a
- modify QUES1-8 so they can contain NULL-values
- replace "NA" with NULL
If you do this the AVG() function will work correctly.