Unanswered

How to calculate percentage completion based on task status

(0) Share

Report

Posted on by Community Power Pla...

Hi. I want to make a label that shows percentage of completion if the Status shows "Completed". I got 9 tasks status fields based on 3 phases. I wanted to show the task completion in both based on the phases and overall task. Please help me on how to do it, either I have to do it on Power Apps, or calculated column in sharepoint list, or Power Automate - as long as I can show the value in Power Apps. Thanks!

Here's how my power apps screen look like:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report
@Anonymous , for task completion based on the overall task, you can try:

Text( Value( CountRows( Filter( [ Dropdown1.Selected.Value, Dropdown2.Selected.Value, Dropdown3.Selected.Value, Dropdown4.Selected.Value, Dropdown5.Selected.Value, Dropdown6.Selected.Value, Dropdown7.Selected.Value, Dropdown8.Selected.Value, Dropdown9.Selected.Value ], (Value = "Completed") ) ) / 9 ) * 100, "#%" )

You can use similar logic if you want to obtain a percentage for each phase.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks, it works! @Amik

Was this reply helpful? Yes No
usoneillb 14 on at

Like (0)

Report

How could I use this same idea but also count “ In progress”

example 15 questions but also give credit for in progress

10 are completed x 100/ 15
3 are in progress x 40 / 15
2 are incomplete x 0 / 15

Was this reply helpful? Yes No