Help with a calculated field

[KellieGardner]

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%

[VictoriaLinn]

Hi @KellieGardner - Is the below what you're looking for? It's the % of Planned Hours / Actual Hours. I wasn't fully clear on what the calculation criteria was here, so let me know if not!

displayname=Custom % Complete
textmode=true
valueexpression=DIV({workRequired},{actualWorkRequired})
valueformat=asPercent

[KellieGardner]

@VictoriaLinn - so the calculation is tricky in my mind so I probably didn't do a good job explaining. And it's Monday.

What we are hoping to see is what the percent complete should be on each task. So not based on any actual work that's happened but a calculation of how much work (percentage wise) should have taken place by now. 

Hopefully that makes more sense. 

Thanks,

Kellie

[Heather_Kulbacki]

@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?

[KellieGardner]

Thanks Heather. This is exactly what I came up with while I was sleeping last night, dreaming about Workfront calculations and it got be partially there. 

[Heather_Kulbacki]

LOL It's so great to know I'm not the only one who dreams in Workfront!

[KellieGardner · Accepted solution]

I finally stumbled upon an answer in the community https://experienceleaguecommunities.adobe.com/t5/workfront-questions/attempting-to-calculate-quot-ex...

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