What if task is not completed by due date. For calculation purpose, it should be considered as completed or not ?
You do not have any column for due date ?
I created a calculated field already for "complete by due date" with "Yes" or "No" response categories. And, yes, there is a column for due date.
Did you try something like below . If yes, then I would need sample workbook with sample data.
completed task - if [complete by due date] = 'Yes' then [task id]
else null end
% = count ([completed task]) / count( [task id])
Thanks! I will try that. I cannot share the data, but I can create a mock file and send on Monday. I will keep you posted. Thanks again!