Work Assignments vs. Actual Work | Community
Skip to main content
K
KevinQu1
Level 10
March 10, 2021
Question

Work Assignments vs. Actual Work

  • March 10, 2021
  • 2 replies
  • 750 views

The Finance person for our group discovered a nifty Task report included with our instance that has this column which itemizes the work assignments for a task:

listdelimiter=<br>

listmethod=nested(assignments).lists

name=Wrk Assignment(s)

stretch=0

textmode=true

type=iterate

valueexpression=CONCAT(right(CONCAT({assignmentPercent}),3),'% (', {workRequired}/60 ,' Hours) - ',{assignedTo}.{name})

valueformat=HTML

width=300

Their request was to break-out the Actual Hours column on the same report in the same way. I'm not very good at iterative lists, but I took a stab at it and it didn't work:

displayname=Act Hours (TEST)

isInlineEditable=false

listdelimiter=<br>

listmethod=nested(assignments).lists

listsort=intAsInt(actualWorkRequired)

querysort=actualWork

shortview=false

textmode=true

type=iterate

valueexpression=CONCAT(right(CONCAT({assignmentPercent}),3),'% (', {actualWorkRequired}/60 ,' Hours) - ',{assignedTo}.{name})

valueformat=HTML

width=300

I feel like in my haste I missed something. Or maybe it's not possible to iterate Actual Hours this way?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
March 10, 2021

Hi - actualWorkRequired is not on the assignment object. The only thing dealing with actuals is

actualWorkCompleted. You can try that and see if that helps, but I'm not sure if it is actual hours or if something like planned hours times percent complete. LOL!

Are you familiar with the API explorer? It is amazing when working with text mode as it tells you what is on the object type you are looking at and what you can reference or use a collection of. https://one.workfront.com/s/api-explorer

K
KevinQu1Author
Level 10
March 10, 2021

You are quite right, I should have looked at the API Explorer rather than assuming it would work.

The field you provided might work, and I am having the finance person doubke-check the numbers.

THANKS!

Terms & ConditionsAccessibility statement

Loading footer...