Percentage

C. Srinidhi Ragunathan

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

Paul Newcome

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))