Invalid Operation for simple formula

I have this formula that is returning INVALID OPERATION

=IF({AMR Location} = "Baltimore Mfg", AVG({AMR Level}), "")

The Location column is just text. The AMR Level is a number that is calculated from a pick list column.

=IF([Level of Professionalism]@row = "1", 1, IF([Level of Professionalism]@row = "2", 2, IF([Level of Professionalism]@row = "3", 3, IF([Level of Professionalism]@row = "4", 4, IF([Level of Professionalism]@row = "5", 5, 0)))))

I can successfully do an average on the whole Level column so I know it's converting to a number correctly.

Why am I getting the error when I try to do an average by location?

Thanks!

Andrea

Find more posts tagged with

Formulas

Accepted answers

Eric Law

Hello @Andrea Zenner,

Have you tried using COLLECT? Try using the following,

=AVG(COLLECT({AMR Level}, {AMR Location}, ="Baltimore Mfg"))

All comments

Eric Law

Hello @Andrea Zenner,

Have you tried using COLLECT? Try using the following,

=AVG(COLLECT({AMR Level}, {AMR Location}, ="Baltimore Mfg"))

Andrea Zenner

That worked! Thanks much! I haven't used COLLECT before. Learned something new today. 😊

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.