Calculating Average students per year

[shefe]

Hello All,

Can someone please help me, i am trying to determine the average time a student have been in our school per fiscal year but based on current semester. Here is a sample.

we are currently in FY2009 and let say we have 5 students enrolled, i want to know the average yrs those students have been here in FY2009 which should be 14 divided by 5 then the average should be 2.5.. Both fields is String and i am using Crystal Report 8.5

Student Name is in Detail a and FYacademicYR is in Detail b
Bobbi Booth
FY2009
FY2008
FY2007
FY2006
FY2005

Savio Zigbi
FY2009

Muhammad Bittu
FY2006

Lucia Zubia
FY2009
FY2008

Shuzyman Kobii
FY2009
FY2007
FY2006

Abdul Jabbar
FY2009
FY2005
FY2004

[Bill Crawley]

The easiest way to do this would be to do it as an SQL Query in a Stored procedure. Then set the Stored procedure as the Datasource to the report.