KYC Posted December 18, 2001 Share Posted December 18, 2001 I need a calculation to arrive at the number of vendors used from a list of sold items.Each item has a vendor number.The find shows vendor 101 may appear 23 times, vendor 203 may appear 15 times. I need to summarize the number of vendors used. The answer I am looking for is:Number of Vendors= 2 Link to comment Share on other sites More sharing options...
LiveOak Posted December 18, 2001 Share Posted December 18, 2001 Create a self-relationship based upon vendor number. Create a calculated field: Mark (calculation, number) = Case(Min(Rel::RecordID) = Record ID, 1, 0)' RecordID is just a unique ID for each record. This will mark the first record for each vendor. If you subsummarize on this field you will get the number of vendors. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8158 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now