Skip to Content
0
Former Member
Jun 16, 2009 at 12:49 PM

Error With Query Formula

16 Views

Hi,

I had Done with Formula with Excveption Aggregation as Average And reference charecterstic as CFBID

DEPT-- MONTH


CFBID----SCORE

ALST-- APR


100--


3

ALST-- MAY


100--


3

ALST-- JUN


101--


4

ALST-- APR


102--


5

-


Overall Score 15

I want the Average Score12/3 = 4.

but I am getting as 15/3 = 5

What to Do any other Solution please