AVG(COLLECT) Formula Questions

Kimberlee Adam

I've looked at a lot of posts already about using this formula and have tried all the suggestions but I'm still getting an UNPARSEABLE error. Hopefully, I'm just doing something simple wrong, like having a common in the wrong spot. But I want to use two criteria... if the MRD column is checked, and the Task Name equals "Requirement Complete", then average the % Complete.

This is my current formula... =AVG(COLLECT([MRD]1:[MRD]109=1, [Task Name]1:[Task Name]109="Solution Complete", [% Complete]1:[% Complete]109))

Andrée Starå

Hi @Kimberlee Adam

I hope you're well and safe!

Try something like this.

=AVG(COLLECT( [% Complete]1:[% Complete]109,[MRD]1:[MRD]109,1, 
[Task Name]1:[Task Name]109,"Solution Complete")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kimberlee Adam

Thank you Andree, always nice to hear from you!

This has definitely gotten me closer but now I'm getting the DIVIDE BY ZERO error... I tried adding the "IF ERROR" to the front but still didn't work.