Help with a calculated field

Question

I won't get into details around why it's needed but we are looking to do a calculated field in a task view that would show us the % complete Workfront thinks a task should be at. For these projects we use Planned Hours to calculate our % Complete

Ideally it would look similar to this

Name	Duration	Pln Hrs	Planned Start Date	Planned Completion Date	% Complete (native Workfront field that currently exists and allows updates)	Calculated field to show what % should be
Task 1	10 days	40 Hours	xx	xx	30.00%	50%
Task 2	100 days	50 Hours	xx	xx	25.00%	75%
Task 3	5 Days	5 Hours	xx	xx	10.00%	5%

KellieGardner · Accepted Answer

I finally stumbled upon an answer in the community https://experienceleaguecommunities.adobe.com/t5/workfront-questions/attempting-to-calculate-quot-expected-percent-complete-quot-if-a/m-p/508011#M39761

displayname=Expected % Complete

textmode=true

valueexpression=IF({plannedStartDate}<$$TODAY,IF(ROUND(((WEEKDAYDIFF({plannedStartDate},$$TODAY)+1)/(WEEKDAYDIFF({plannedStartDate},{plannedCompletionDate})+1)*100),2)>100,"100%",CONCAT(ROUND(((WEEKDAYDIFF({plannedStartDate},$$TODAY)+1)/(WEEKDAYDIFF({plannedStartDate},{plannedCompletionDate})+1)*100),2),"%")),"0%")

valueformat=HTML

Heather_Kulbacki · Answer

@kelliegardner how would you want to go about determining what that %complete should be?

Is a matter of (task 1, for example), the planned start date was 5 days ago in a 10 day duration task, so we should be 50% done by now? Workfront will divide your 40 hours evenly over those 10 days, so I don't think you need to consider hours in there.

For that, have you tried something along this line: ($$TODAY-plannedStartDate)/duration

Or is there some other expectation for what the %complete should be?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded