View: display the result of a calculation between two fields in a column

You can use text mode in a column to display a calculation between two fields.

For example, if you want to find out the number of week days that elapsed between two dates, you can use text mode syntax and data expressions to calculate this difference.
For example, you can calculate the week day difference between the Planned Completion Date and the Actual Completion Date of a task and display the result in a column.

You can use any other two dates in this calculation (Actual Start, Actual Completion, Projected Start, Projected Completion, etc).
For more information about calculated data expressions, see Overview of calculated data expressions.

Access requirements

You must have the following access to perform the steps in this article:

Adobe Workfront plan*
Any
Adobe Workfront license*

Request to modify a view

Plan to modify a report

Access level configurations*

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a view

NOTE

If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Display the result of a calculation between two fields in a column

To add this column to a task view:

  1. Go to a list of tasks.

  2. From the View drop-down menu, click New View.

  3. Click Add Column, then Switch to Text Mode.

  4. Hover over the text mode area, and click Click to edit text.

  5. Remove the text you find in the Text Mode box, and replace it with the following code:

    displayname=Week Day Difference
    textmode=true
    valueexpression=WEEKDAYDIFF({plannedCompletionDate},{actualCompletionDate})
    valueformat=HTML
    
  6. (Optional) To aggregate the values displayed in the view in a grouping, follow the steps described in Grouping: display the result of aggregating multiple calculated values in a grouping.

  7. Click Save, then Save View.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43