AVG formula and Invalid Data Error

Hello,

I seem to have hit a bit of a pickle (or an afternoon brain fart) while trying to create a roll up.

Essentially what I'm trying to do is create a roll up of averages by month and my formula is returning an Invalid Data Error. I checked the reference columns and they are indeed date columns but beyond that, it should be pretty straight forward:

=AVG(COLLECT({Assigned People}, {Target Date}, MONTH(@cell) = Month@row))

Is there something glaringly obvious that I'm missing?

Find more posts tagged with

Accepted answers

All comments

Leibel S

What is in the assigned people column?

kioshi43

It's a column that has the number of people assigned

Leibel S

@kioshi43

Try adding IFERROR around the MONTH() function.

=AVG(COLLECT({Assigned People}, {Target Date}, IFERROR(MONTH(@cell),0) = Month@row))

If any of your dates are not actual dates then it will result in an error

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.