Re: How to calculate percentage completion based on task status
@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
