Average Formula for Child Rows on different column

Stephany Gonzales

Great Afternoon ! I am having trouble to create a simple average formula for child rows. Please see attached the picture. On the red field I would like to get the average of the child rows, from the column named TOTAL OWE-LIVE/INV. AMOUNT. In other words, that cell should show $11,266.88.

Your help is greatly appreciated!

Thank you

L_123

Sorry, bad habit, I just copied the column name from your message and didn't even check if it was the same as the screenshot.

L_123

=avg(children([TOTAL OWE-LIVE/INV. AMOUNT]@row

Stephany Gonzales

Great Morning @L_123 , thank you. Could you please take a look of the formula? It keeps showing the UNPARSEABLE message.

Capture1.PNG

Capture.PNG

Andrée Starå

Hi @Stephany Gonzales

I hope you're well and safe!

Try something like this.

=AVG(CHILDREN([TOTAL OWE - LIVE / INV. AMOUNT]@row

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Stephany Gonzales

Yaaaaassssss @Andrée Starå ! thank you very much for your help! :)

L_123

Sorry, bad habit, I just copied the column name from your message and didn't even check if it was the same as the screenshot.

Stephany Gonzales

no worries @L_123 , thank you for your help too!

Andrée Starå

@Stephany Gonzales

Excellent!

You're more than welcome!

@L_123 Easy to miss!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!