Average Collect formula

Hi, I have a question regarding a formula:

We want to get an average result from few columns:

First will be the Scoring (Score)
Second will be the employee name (Name)
Third is the check type we did (Check Type)
Fourth is the month (Month)

Formula that we used:

=AVG(COLLECT({Score}, {Name}, [Name]@row ), {Check Type}, "Compliance Check", {Month}, CONTAINS("September", @cell )), but it returns "Invalid Operation" error

Please could you advise which reference is causing issue?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try removing the closing parenthesis from after Name@row.

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.