Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Calculated Task Columns

Avatar

Level 2

I have been working on some Text mode inputs to find the difference between the "Total # of deliverables" & "total # of deliverables completed". {Green Square in image}

 

My goal is to report on the project status for the "# of remaining deliverables" {Yellow Square in Image}

 

Screen Shot 2022-10-20 at 3.37.23 PM.png

 

I have found the article with the function I am trying to include what am i missing from a text mode perspective? 

ARTICLE

Screen Shot 2022-10-20 at 3.46.25 PM.png

1 Accepted Solution

Avatar

Correct answer by
Level 2

Here is the solve that we discovered internally with my team.

 

displayname=# of Deliverables Remaining
textmode=true
valueexpression=SUB({DE:Total # of Deliverables}, {DE:# of Deliverables Completed})
valueformat=HTML

 

CALLOUT:

DE: for custom column names

Type fields exactly as shown 

SUB = Difference between fields

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

Here is the solve that we discovered internally with my team.

 

displayname=# of Deliverables Remaining
textmode=true
valueexpression=SUB({DE:Total # of Deliverables}, {DE:# of Deliverables Completed})
valueformat=HTML

 

CALLOUT:

DE: for custom column names

Type fields exactly as shown 

SUB = Difference between fields