Jump to content

Finding and summarizing calculation


KYC
 Share

This topic is 7248 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 7248 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.