Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.

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.