Avg(collect) across multiple columns, for specific criteria = unparseable
I am trying to get an overall average % complete for all locations for their "Adoption" phase.
While trying to debug it, I got an average of everything to work for my "Average Score" summary field. I used this formula:
=AVG(COLLECT([NA Hub]1:[Haarlem MSDIS]140, [NA Hub]1:[Haarlem MSDIS]140, ISNUMBER(@cell)))
Next, I am trying to build on that to add in the "TC1 Stage Gate" equal to "Adoption" and get that into the "Adoption Average Score" summary field. But I have run into an #unparseable error for the new formula that I can't figure out.
=AVG(COLLECT([NA Hub]1:[Haarlem MSDIS]140, ISNUMBER(@row),[TC1 Stage Gate]:[TC1 Stage Gate],"Adoption"))
Help Article Resources
Check out the Formula Handbook template!