#Divide by zero error for AVG COLLECT

Peggy

My formula is giving an error. it works fine until I try to add the month. The month calculated field is a number/text field. What else could be the issue?

=AVG(COLLECT({DYS to Completion}, {Application}, [Column5]@row, {Month}, =1))

Archiduc

I think you just need to put 1, not =1

Edit: nope I just made a test that looked okay with =1, I think we're gonna need to know what your references go to. What kind of error are you getting? is there any error in the month column too?

Peggy

Hi,

the error is below. When I remove the month calculation, I get the average. but when I add back the {Month}, =1 i get the error.

#Divide by zero error for AVG COLLECT