COUNT/DISTINCT/COLLECT question

Lorna Anderson

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)))

So it should return 7

Any advice?!? 😓

Paul Newcome

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

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.