Value does not exceed

[rose12346]

Hello- We are currently running Crystal Reports 9 and I want to create a formula (if this is the best solution) that will identify Locations within the D.C. that are only single sequences from those that are multiple here is some information;
We have locations, for example NNRC010101 sequence 1.00 then NNRC010101 sequence 2.00 etc and some locations only have sequence 1.00 I would like to get a distinct count of the locations with ONLY one sequence versus the locations that have multiple sequences. Is there a formula I can write to accomplish this? The report data I have is all locations with their corresponding sequence number.

Thank you

[Ned Pepper]

You are not providing enough information to work with. In general you can create a formula that provides a distinct count using the build in summary function DistinctCount.