Adding IFERROR to AVG(COLLECT
Hi, I am needing to add an IFERROR to the following formula to return a "-" if no data is present. I attempted to use a few examples seen in other questions but it keeps giving an invalid argument.
=AVG(COLLECT([FPY %]:[FPY %], Date:Date, AND(@cell >= DATE(2020, 11, 29), @cell <= DATE(2021, 1, 2))))
Help Article Resources
Check out the Formula Handbook template!