How to get the average number of days within a quarter

here is my formula, but I keep getting an error. I can get the average, but now I want to know the average within Quarter 1

=AVG(COLLECT({DYS to Completion}, {Qtr}, "1"))

Find more posts tagged with

Formulas

Accepted answers

All comments

kira11

If you have a column that says the quarter, I think you could do an average if, something like:

=AVERAGEIF({Qtr}, 1, {DYS to Completion})

Peggy

I left out a criteria, need to know the average days to completion for a specific application within the quarter

=AVERAGEIFS({Qtr}, 1, {Application}, =[Column5]@row, {DYS to Completion})

kira11

Oh got it, I think you could use the COLLECT() then. I think its the quotes around the 1, maybe try:

=AVG(COLLECT({DYS to Completion}, {Qtr}, 1, {Application}, [Column5]@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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.