Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

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.