To aggregate several fields in Adobe Workfront and display that aggregate value in a new field, you can do the following:
A calculated custom field in a Custom Form
For more information about adding a calculated custom field to a Custom Form, see the section Add a calculated field to a custom form in the article Add calculated data to a custom form.
Although you use text mode to build both calculated fields and calculated columns, the syntax for building them differs. Refer to the articles listed above to learn how to build calculated fields and calculated columns. For information about the different syntax used in calculated data expressions such as calculated custom fields and columns, see the section Syntax of calculated custom fields vs. calculated custom columns in this article.
You can use the same calculations in both calculated fields as well as a calculated column. However, depending on what your purpose for these calculations is you might want to consider building one versus the other.
Although the functions that you use are the same, the syntax for building an expression in a calculated custom field can be different than it is for building a calculated custom column.
In a custom field, on a custom form for tasks, you would use the following to generate the name of the parent project of the task where the custom form is attached:
In a custom column in a report, you would use the following to add a Project Name custom column on a task report:
The same syntax applies to all text-mode reporting elements where calculated expressions are used: views, filters, groupings, prompts.
The differences between the two syntaxes are:
|Calculated custom field||Calculated custom reporting element|
Use the name of the fields as they appear in the Workfront interface.
Example: Example of field name used in a calculated custom field:
Use the name of the objects or fields as they appear in the Workfront database. The names of objects and fields are spelled in lower case or camel case, if they are compound names.
For an inventory of all Workfront objects and fields as they appear in the database, see API Explorer.
Example: Example of field name used in a calculated custom reporting element:
|Enclose field names in parentheses or curly brackets||
Do not enclose field names in brackets or parentheses when using them in a
Enclose field names in curly brackets when using them in a
|Separate the fields by periods||
Separate the fields by colons when using them in a
Separate the fields by periods when using them in a
For more information about the syntax you must use in a calculated custom column, see Text Mode overview.
On an object’s main page, clicking the More icon , then clicking Recalculate Expressions
Bulk editing multiple objects when Recalculate Custom Expressions is enabled
Editing a custom form when Update previous calculations is enabled for the calculated custom field
When you want real-time data to be available on a report.
Calculated views are always fresh because the calculation is made when the report is run or the view is applied.
When you have no plans to group by aggregated results nor use this information in a chart.
When you do not plan to aggregate the data beyond the aggregation that is calculated in the column (data can be aggregated only once).
When you want the calculation to include a reference to the current date using the $$TODAY or $$NOW wildcards.
Do not use this reference in calculated custom fields because they only recalculate when the attached object is edited. These types of calculations become outdated.
For examples of calculated custom fields, see Calculated custom data in reports.
For examples of calculated custom columns in views see the following articles: