Expand my Community achievements bar.

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

Avatar

Level 2

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! 

2 Replies

Avatar

Community Advisor

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 : )