I am trying to calculate the average number of months (Jan, Feb, etc.) a person has in their records based on the following:
Each person has several records and an associated datetime field. I am interested in adding the DISTINCT number of MONTHS per person, and then dividing that number by the total number of people.
The various formulas and running totals I've tried so far are not correct. Can you suggest a method for getting the average number of months a person has in their records per all the people in the report?