% Complete of children row so parent row is 100% of children
Good afternoon, we have a Parent Row that is the sum of the children, in the column next to it we need to give each row a % value based on that rows % of the total in the parent row. How do we keep the parent row constant because when we copy the formula down it reads the next row down
Best Answer
-
Thank you @Bassam Khalil , that worked, is there a way to do a formula so it always goes to the parent row? When we add multiple scope items with parent and child rows on the same sheet we were hoping we could collapse the rows and copy the formula in the parent row
Thanks
Answers
-
Hi @BESP10
Hope you are fine, please try the following formula:
=[install Bar]@Row / $[install Bar]$649
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"
-
Thank you @Bassam Khalil , that worked, is there a way to do a formula so it always goes to the parent row? When we add multiple scope items with parent and child rows on the same sheet we were hoping we could collapse the rows and copy the formula in the parent row
Thanks
-
Yes I can configure it for you but I need to share me as an admin on a sample copy with sample data.
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
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!