Formula for AVG when only specific rows should be calculated

Hello,

Working on a formula that should average number of days worked but also meets two other specific criteria and does not count any rows that are blank as 0. Below is my formula but not confident is calculating the way I need it to. Thoughts?

=AVG(COLLECT({#Worked}, {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

Find more posts tagged with

Accepted answers

Paul Newcome

That should be working. If you wanted to specify to exclude blanks just to be sure, it would look something like this...

=AVG(COLLECT({#Worked}, {#Worked}, @cell <> "", {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

All comments

Paul Newcome

That should be working. If you wanted to specify to exclude blanks just to be sure, it would look something like this...

=AVG(COLLECT({#Worked}, {#Worked}, @cell <> "", {Due Date}, >DATE(2020, 12, 31), {Status}, =[Formula Descriptor]@row))

Tbech

Thanks as always!

Paul Newcome

Happy to help. 👍️

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.