Expand my Community achievements bar.

The ability to create ideas and blogs are temporarily disabled. We apologize for the inconvenience.

Add Planned Cost data on Assignment Object

Avatar

Level 2

6/5/18

Workfront does not have a data field for planned labor cost for the assignment object. Workfront users do have access to an assignment's logged hours via the actualWorkCompleted field, though users cannot chart this field as it can only be accessed through Syntax mode.

I can calculate the planned labor cost of an assignment with the following syntax text mode code:

aggregator.displayformat=currencyStringCurrencyRounded
aggregator.function=SUM
aggregator.valueexpression=PROD(DIV({workRequired}/60),{role}.{costPerHour})
displayname=Planned Cost per Assignment
textmode=true
valueexpression=PROD(DIV({workRequired}/60),{role}.{costPerHour})
valueformat=currencyStringCurrencyRounded

Having this as a native field in Workfront would allow us to chart the data.