-
September 11th, 2014, 08:19 AM
#1
Value does not exceed
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
-
September 15th, 2014, 10:07 AM
#2
Re: Value does not exceed
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|