Weighted Average With a Condition

Emma W

Is it possible to gather a weighted average, with a condition?

My starting formula is

but I would like to build in a condition. In other formulas this has taken the form of

I can't work out how to bring these together / if it is possible.

Grateful for any thoughts anyone may have!

Emma

Find more posts tagged with

Formulas

Accepted answers

All comments

Brett Wyrick

Hey Emma. Trying to wrap my head around what you're trying to accomplish here, so couple of questions for you:

Could you post a screenshot of the columns you're using? And what your use case is here, what you're trying to accomplish?

I'm thinking you could utilize something like:

=IF(SUM(CHILDREN([Not In Scope]@row)) >= 1, AVGW(CHILDREN(), CHILDREN(Weightage@row)))

Which basically says, if the sum of the Children row column "Not In Scope" is 1 or greater, show me the original formula).

Does that make sense? I think this ought to get you on the right track, at least.

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.