COLLECT with an OR criteria

I have a COLLECT statement with multiple criterias, one being and involving an OR. In the below formula I have a Discipline column where I want to bring back Reading or Literature for a particular year.

=JOIN(COLLECT({SA Grid: ELA}, {SA Grid: Go/NoGo}, ="[X]", {SA Grid: Year}, =Year@row, {SA Grid: Discipline}, OR(="Reading", ="Literature"), CHAR(10) + "==============" + CHAR(10)))

Potentially, the result for 2023 could look something like... because both Reading and Literature would be considered under the ELA discipline

Find more posts tagged with

Accepted answers

Paul Reeves

@Samuel Mueller - That did it. I think I was so far into the weeds and brain dead that I was not seeing that I had not closed out the COLLECT.

All comments

Samuel Mueller

@Paul Reeves try adding @cell in your or criteria

=JOIN(COLLECT({SA Grid: ELA}, {SA Grid: Go/NoGo}, ="[X]", {SA Grid: Year}, =Year@row, {SA Grid: Discipline}, OR(@cell="Reading", @cell="Literature"), CHAR(10) + "==============" + CHAR(10)))

Paul Reeves

@Samuel Mueller thanks for the suggestion however I am still getting the Incorrect Argument Set.

Samuel Mueller

@Paul Reeves try taking off one of the last parenthesis

=JOIN(COLLECT({SA Grid: ELA}, {SA Grid: Go/NoGo}, ="[X]", {SA Grid: Year}, =Year@row, {SA Grid: Discipline}, OR(@cell="Reading", @cell="Literature"), CHAR(10) + "==============" + CHAR(10))

Let me know if that works ^

Paul Reeves

@Samuel Mueller No that does not seem to solve it. The formula keeps putting on the outside parenthesis for the JOIN function. There should be 3 functions and 3 sets of parenthesis: JOIN, COLLECT, OR.

Seems like it should work though.

Samuel Mueller

@Paul Reeves Thank you you are correct, you need the second parenthesis after the or to finish the collect formula, like this

=JOIN(COLLECT({SA Grid: ELA}, {SA Grid: Go/NoGo}, ="[X]", {SA Grid: Year}, =Year@row, {SA Grid: Discipline}, OR(@cell="Reading", @cell="Literature")), CHAR(10) + "==============" + CHAR(10))

Try that one

Paul Reeves

@Samuel Mueller - That did it. I think I was so far into the weeds and brain dead that I was not seeing that I had not closed out the COLLECT.

Samuel Mueller

I missed it too! Glad you got it working.

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.