Expand my Community achievements bar.

SOLVED

Help with a calculated field

Avatar

Community Advisor

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

NameDurationPln HrsPlanned Start DatePlanned Completion Date% Complete
(native Workfront field that currently exists and allows updates)
Calculated field to show what % should be
Task 110 days40 Hoursxxxx30.00%50%
Task 2100 days50 Hoursxxxx25.00%75%
Task 35 Days5 Hoursxxxx10.00%5%



1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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




View solution in original post

6 Replies

Avatar

Community Advisor

Hi @KellieGWAB - 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

Avatar

Community Advisor

@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




Avatar

Community Advisor

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

Avatar

Community Advisor

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. 




Avatar

Community Advisor

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

Avatar

Correct answer by
Community Advisor

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