Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

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.