Work Assignments vs. Actual Work

[CalvinFold]

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?

[AnthonyIm]

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

[CalvinFold]

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!