Average Days to complete within a date range
I would kindly like to ask for some assistance. I am trying to get the average number of "Days to Complete" if the "Resolved Date" is within March.
I've tried the formula below but I am getting an #UNPARSABLE error.
=AVG(COLLECT({2021 Archive Days to Complete Range},[Days to Complete]:[Days to Complete], {2021 Archive Resolved Date Range}, >=DATE(2021, 3, 1), {2021 Archive Resolved Date Range}, <=DATE(2021, 3, 31) 0))
Best Answers
-
Try this...
=AVG(COLLECT({2021 Archive Days to Complete Range}, {2021 Archive Resolved Date Range}, >=DATE(2021, 3, 1), {2021 Archive Resolved Date Range}, <=DATE(2021, 3, 31)))
-
Happy to help. 👍️
Answers
-
Try this...
=AVG(COLLECT({2021 Archive Days to Complete Range}, {2021 Archive Resolved Date Range}, >=DATE(2021, 3, 1), {2021 Archive Resolved Date Range}, <=DATE(2021, 3, 31)))
-
You got it Paul!
Thank you so much for your assistance. You provided me with the answer that I needed and also brought the collect function to my attention which I was not familiar with.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!