Adding IFERROR to AVG(COLLECT

Kacy Hayes

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))))

L_123

=iferror(AVG(COLLECT([FPY %]:[FPY %], Date:Date, AND(@cell >= DATE(2020, 11, 29), @cell <= DATE(2021, 1, 2)))),"-")

I didn't check your formula, but if the formula is correct above is how you would add an iferror to it.

L_123

=iferror(AVG(COLLECT([FPY %]:[FPY %], Date:Date, AND(@cell >= DATE(2020, 11, 29), @cell <= DATE(2021, 1, 2)))),"-")

I didn't check your formula, but if the formula is correct above is how you would add an iferror to it.

Kacy Hayes

Well not sure what I was entering wrong before but that did the trick. Thank you for the help.