Create a column to represent the sum of two other columns in the same report | Community
Skip to main content
TaraMc2
TaraMc2
Level 2
July 3, 2024
Question

Create a column to represent the sum of two other columns in the same report

  • July 3, 2024
  • 2 replies
  • 891 views

I am trying to create a column within a report that represents the sum of two other columns in a report. I'm also trying to create a column that compares the number of days from planned start date to planned completion date. Does anyone have text mode that will work for these two items? 

 

Thank you! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

_Manish_Singh
_Manish_Singh
Level 9
July 3, 2024

Please see the example in this article: View: display the result of a calculation between two fields in a column | Adobe Workfront

For Sum the function would be SUM({field1},{field2})

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
July 5, 2024

Hi there,

For the column in your report (value expression), I have a couple options and you can modify:
Days between entry date & actual start date:
displayname=[whatever you want to call the column]
textmode=true
valueexpression=CONCAT(ROUND(WORKMINUTESDIFF({entryDate},{actualStartDate})/480,2)," Days")
valueformat=HTML

Days between actual start date & actual completion date:
displayname=[Turnaround time or whatever you want to call the column]
textmode=true
valueexpression=CONCAT(ROUND(WORKMINUTESDIFF({actualStartDate},{actualCompletionDate})/480,2)," Days")
valueformat=HTML

For summing 2 fields in a column:
displayname=[whatever you want to call the column]
textmode=true
valueexpression=SUM({field1},{field2})
valueformat=HTML

If this helped you, please mark correct to help others : )
Terms & ConditionsAccessibility statement

Loading footer...