Formulae to calculate AVG days for Task completion meeting certain conditions

=AVG(COLLECT({Type}, "Plan Change", {Status}, "DocuSign Approved"), {Days to complete})

I am trying to calculate the Average no of days to complete the task. The {Days to complete} is a column where count of days is being populated by calculating the start and end date.

The two conditions are 1. Plan change under Type column and 2. DocuSign Approved under Status Column.

Its throwing an error - INCORRECT ARGUMENT

Please help.

Find more posts tagged with

Accepted answers

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

Try this one...

=AVG(COLLECT({Days to Complete}, {Type}, "Plan Change", {Status}, "DocuSign Approved"))

Gaurav Chauhan

Thank you for sharing the revised formulae.

Its now giving me the error #DIVIDE BY ZERO... I assume we are closer to the result with one missing step

Gaurav Chauhan

Thank for helping. The error resolved...

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.