AVG( IF [datafield] == 999 THEN NULL ELSE [datafield] END)
The null values shouldn't impact your average.
NICE! That worked. Thank you. (I am slightly brain dead this morning)
I've been trying to shortcut it with:
if [datafield] == 999 then AVG([datafield]) end