Formula on Grand Parents row
Hi everyone,
Please I do not know what I am doing wrong with my formula on % complete column, I have intention of calculating average on a grand parent 'the first row' which has other parents as indent.
I used the formula
=AVG(CHILDREN([Days to due Date]@row))
It is giving me above 1000%. please what do I do?
Ps: I do not know if the formula is appropriate. It is the same I used on parent rows and it works well.
Best Answer
-
Hi @Abiola
Hope you are fine, if you want the formula to resident in the parent row of [Days to due Date] column to calculate the CHILDREN AVG then try the following formula:
=AVG(CHILDREN())
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Abiola
Hope you are fine, if you want the formula to resident in the parent row of [Days to due Date] column to calculate the CHILDREN AVG then try the following formula:
=AVG(CHILDREN())
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
-
Excellent, i will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!