Help with #Divide By Zero

Travis Horton

How do I adjust the syntax in this formula to avoid the '#Divide By Zero' error? I would like it to return a black cell for the months where this no data yet. I've tried using IFERROR in a variety of ways but that's either not the right solution or I'm not applying it correctly.

=AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue"))

Christina09

@Travis Horton

Have you tried =IFERROR(AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue")),"")

Travis Horton

@Christina Lam Yes! That worked. I was so close - didn't have "" out side the last double close parenthesis.

Christina09

@Travis Horton

Have you tried =IFERROR(AVG(COLLECT({Order Submission Time}, {Received By Month}, AND(@cell <= DATE(2022, 3, 31), @cell >= DATE(2022, 3, 1)), {OM Orders Received}, "Angie Blue")),"")

Travis Horton

@Christina Lam Yes! That worked. I was so close - didn't have "" out side the last double close parenthesis.