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?