Avg/Collect formula to enter zero

dzenus

Hello,

I have this formula which works as I'd like but what I'm missing is if the answer is zero I want the formula to give me 0 as a response, instead I'm getting #Divide by zero. Any suggestions of what I'm missing?

=AVG(COLLECT({days complete}, {Sourcing Owner}, [Contract Manager]@row, {Completed Requests by Month Range 1}, "May"))

heyjay

=IFERROR(AVG(COLLECT({days complete}, {Sourcing Owner}, [Contract Manager]@row, {Completed Requests by Month Range 1}, "May")),0)

heyjay

=IFERROR(AVG(COLLECT({days complete}, {Sourcing Owner}, [Contract Manager]@row, {Completed Requests by Month Range 1}, "May")),0)