Hi, I'm trying to count the number of unique Third parties on a contract tracker sheet. I want to be able to count the unique numbers of Third parties by Contract Group So in the snip below: * Supplier 3 and Supplier 4 would equal a count of 2 Not Active. * Active would equal a count of 1 * Requested would equal a count of 2 * Future would equal a count of 2 I've tried various permutations using COUNT(DISTINCT(COLLECT….. e.g., =COUNT(DISTINCT(COLLECT([Third Party]:[Third Party], [Contract Group]:[Contract Group], <>"2-Active"))) …but it is the bit where the suppliers are various Contract Groups that is the sticking point. As ever, any thoughts would be great.

Count unique suppliers active / not active

A_C

Hi,

I'm trying to count the number of unique Third parties on a contract tracker sheet.

I want to be able to count the unique numbers of Third parties by Contract Group

So in the snip below:

Supplier 3 and Supplier 4 would equal a count of 2 Not Active.
Active would equal a count of 1
Requested would equal a count of 2
Future would equal a count of 2

I've tried various permutations using COUNT(DISTINCT(COLLECT…..

e.g., =COUNT(DISTINCT(COLLECT([Third Party]:[Third Party], [Contract Group]:[Contract Group], <>"2-Active")))

…but it is the bit where the suppliers are various Contract Groups that is the sticking point.

As ever, any thoughts would be great.

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@A_C

Are you putting this information in a metric sheet? Or on the current sheet?

A_C

Hi Mark,

I'm going to put it in a metric sheet, so using the ranges, but also would like to solve it in it's own sheet, so I can have the option of summaries etc.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.