avg calculation in reports

Question

the table data as follows
------------------------

id  answer  score
--- ------  ------ 
1     Y      100
2     N/A      0
3     N        0
4     Y      100

now in report group header i am calculating avg(amt) ...now i should not consider the answer N/A row at the time of doing avg...

Answer 1

0

You can exclude unwanted record through where condition in query. e.g.

SELECT AVG(FIELD) FROM GROUP_HEADER WHERE answer <>'N/A'

answered Sep 16 '11 at 12:11 AM

Amardeep
1.3k ● 74 ● 83 ● 87

not in a query, we are doing at report level

Sep 16 '11 at 12:28 AM Murali

(comments are locked)

avg calculation in reports

Follow this question

Related Questions