Embed hierarchy function as the range within the COLLECTION function

Diaz

I amy trying to execute the following function.  Does anyone know if it, or something like it, is possible:

 

= AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER()))

SmSulli

Diaz,

I believe if you throw an @cell in the ISNUMBER function, you'll be good to go.

= AVG(COLLECT(CHILDREN(), CHILDREN(), ISNUMBER(@cell)))

Shawn