Skip to Content
0
Former Member
Dec 13, 2007 at 02:40 PM

Top N Sort on formula field

14 Views

Post Author: rschildt

CA Forum: General

I have data on crashes at intersection in our City, and am trying to create a "Top 25 Crash Rate Intersection" report. I have a formula that calculates the crash rate of the intersection (counting the number of records and dividing it by the traffic count info in another field in the database).

I then use the "Group Sort Expert" and can do a Top N based on my count of the crashes, but not on my formula to calculate the rate. Is ther a way to use my formula to create a Top N sort?