Calculating percentage of conversions

[Matthew Miller]

Hey, I have a calculation that I can't even begin to guess at the solution; all help appreciated.

We have a database of students in various stages of the admissions process (eg: Inquired, Visiting, Applied, etc). We keep a history of their changes in status, including the status, the effective date of change and the amount of time elapsed since the previous change in status. So far, so good.

Our admission director would like a report showing the number of students in each stage of the process (no problem), the amount of time it's taking to move them between stages (no problem), and the percentage conversion rate (problem). That last means, if we have 100 students that moved from Inquired to Visited during the previous quarter, what percentage of the total in Inquired status does that represent?

I am totally baffled regarding how to calculate this, since it would seem to depend on summary information in a different sub-summary group. Any help or ideas would be greatly appreciated!

I hope this was clear; if you need more detail on the database or the problem, let me know.

[David Jondreau]

You can create a calculation field based on a summary field using GetSummary(), but frankly I find it too annoying.

Seems like all you need is a count of the number of Inquired in one quarter and the count of Visiting in the next. Tell us more about how you would calculate those numbers and your table structure and maybe we can help.