able to calculate average from a single record