Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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.