COUNT/DISTINCT/COLLECT question

I've read the Q&A on these functions but i still can't get mine to work. I'm evaluating two columns: pkg_num, and subprojectorder, then want a count of the Distinct project numbers that meet that criteria

=COUNT(DISTINCT(COLLECT([project_number]1:[project_number]28), [pkg_num]1:[pkg_num]28, ="CD01", subprojectorder1:subprojectorder28,>0)))

Screen Shot 2020-04-27 at 2.41.21 AM.png

So it should return 7

Any advice?!? 😓

Find more posts tagged with

Accepted answers

Paul Newcome

I agree with @Joanna Waligora. I believe it is just that extra closing parenthesis tucked in there.

All comments

Joanna Waligora

I think this may just be a typo. Drop the closing bracket after [project_number]28, and see if it works.

=COUNT(DISTINCT(COLLECT([project_number]1:[project_number]28, [pkg_num]1:[pkg_num]28, ="CD01", subprojectorder1:subprojectorder28,>0)))

Paul Newcome

I agree with @Joanna Waligora. I believe it is just that extra closing parenthesis tucked in there.

Lorna Anderson

Sorry but I don't see it - I have 3 open and 3 close parenthesis?!?

Lorna Anderson

OK - got it! Thanks for you help!!

😀

Paul Newcome

Great! Please don't forget to flag the most appropriate response (Joanna's) as "helpful" so that others encountering a similar struggle can know that a possible solution may be found here.

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.