Formulae to calculate AVG days for Task completion meeting certain conditions

Gaurav Chauhan

=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.

Paul Newcome

Happy to help. 👍️

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. 👍️