TMcCrillis
IS-IT--Management
I'd like to create an average in Crystal 8.5 however, I need the calculate to exclude any quantity of 0 or 1 from the average.
Part Days
1A 20
1A 37
1A 5
1A 1
1A 0
1A 3
I have an average calculated already which would give me an average of 11 - - What I'm looking for is 16.25 because we know that 0 and 1 days are exceptions to the reporting we're doing and only distort the data.
Suggestions?
Part Days
1A 20
1A 37
1A 5
1A 1
1A 0
1A 3
I have an average calculated already which would give me an average of 11 - - What I'm looking for is 16.25 because we know that 0 and 1 days are exceptions to the reporting we're doing and only distort the data.
Suggestions?