Expand my Community achievements bar.

SOLVED

Sum of Two Columns in Issue report not working

Avatar

Level 3

I am trying to put together an Issue report that includes a column to calculate actual hours logged to both the issue and the resolve project.  This is just to add the values from both actual hours columns in the image below (which do have values) and not even to sum at the grouping level, but the calculation below is not working. I assume I'm making a silly mistake since this seems relatively simple.  Thanks!


valueexpression=SUM({actualWorkRequired},{resolveProject:actualWorkRequired})
textmode=true
valueformat=HTML
displayname=Total Hours


Screenshot 2023-08-10 at 1.15.28 PM.png

1 Accepted Solution

Avatar

Correct answer by
Level 9

Your syntax is ever so slightly off in how you're referencing the resolving project's data. In a valueexpression the syntax requires separating with a period rather than a semi-colon. So using your example, you would want {resolveProject}.{actualWorkRequired}.

 

Because having three entirely separate format/syntax methodologies to display the same data in different parts of the system makes sense to someone...somewhere...I'm sure. 

 

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/text-mode-syntax...

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/edit-text-mode-i...

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

Your syntax is ever so slightly off in how you're referencing the resolving project's data. In a valueexpression the syntax requires separating with a period rather than a semi-colon. So using your example, you would want {resolveProject}.{actualWorkRequired}.

 

Because having three entirely separate format/syntax methodologies to display the same data in different parts of the system makes sense to someone...somewhere...I'm sure. 

 

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/text-mode-syntax...

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/edit-text-mode-i...

Avatar

Level 3

Thank you, Katherine!  I forgot about that syntax entirely.

 

Much appreciated!