Average collect w/ 3 criteria

AGorgei

I'm attempting to average the %age passed for a specific month and year for a specific team.

I successfully used the below to average the total by month and year, but can't figure out how to add the team.

=AVG(COLLECT([%Passed]:[%Passed], [Month 2]:[Month 2], =1, Year:Year, =2024)

I tried the below, but am getting a #UNPARSEABLE error

=AVG(COLLECT([%Passed]:[%Passed], [Month 2]:[Month 2], =1, Year:Year, =2024, Team:Team, =Workforce Admin))

Thanks in advance!

Find more posts tagged with

Formulas

Accepted answers

AGorgei

@MichaelTCA Thanks for the suggestion...I figured it out! I needed to put the team name in quotes

"Workforce Admin"

=AVG(COLLECT([%Passed]:[%Passed], [Month 2]:[Month 2], =1, Year:Year, =2024, Team:Team, ="Workforce Admin"))

Thanks again!

All comments

MichaelTCA

Hello @AGorgei,

One possibility is how the last "criterion" was spelled. I'm not sure if you copy and pasted the function into this thread, but you could try entering [Workforce Admin]@row into the end of the function.

When you type a value you like =1 or =2024, the function is looking at the cell value within that column. It has a specific reference. Unless you specify who in the team to average information for, you will have to use the @row option.

AGorgei

@MichaelTCA Thanks for the suggestion...I figured it out! I needed to put the team name in quotes

"Workforce Admin"

=AVG(COLLECT([%Passed]:[%Passed], [Month 2]:[Month 2], =1, Year:Year, =2024, Team:Team, ="Workforce Admin"))

Thanks again!

MichaelTCA

@AGorgei

Nice! Glad you were able to figure it out.

Lori C

Can you combine the average of 2 workgroup, such as when you have 9 work groups and 3 regions? The data is coming in my workgroups and I need to average the data by region.

Thank you for any recommendations,

Lori

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.