Percentage
Hi
I need to calculate the cumulative percentage of n number of tasks completed under a parent row.
For example, I have 10 objects to report within three days and on the first day I report 4 objects, on the second day 3 objects and on the last day 3 objects. This means, 40% of the work is complete on the first day, 70% on the second day and 100% on the third.
Is it possible to show the cumulative percentage on the parent row ?
Thank you
Comments
-
How do you have your "Complete" displayed? Is it text or is it a percentage. If it is text (whether dropdown or otherwise) you can use
=(COUNTIFS(CHILDREN([Status Column Name]@row), "Complete")/COUNT(CHILDREN([Status Column Name]@row))) * 100 + "%"
If it is already displayed as a percentage and you just need to average them, you can use
=AVG(CHILDREN))