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)))
So it should return 7
Any advice?!? 😓
Best Answer
-
I agree with @Joanna Waligora. I believe it is just that extra closing parenthesis tucked in there.
Answers
-
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)))
-
I agree with @Joanna Waligora. I believe it is just that extra closing parenthesis tucked in there.
-
Sorry but I don't see it - I have 3 open and 3 close parenthesis?!?
-
OK - got it! Thanks for you help!!
😀
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!