Sum of Two Columns in Issue report not working

[CSibley]

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

[KatherineLa · Accepted solution]

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...

[CSibley]

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

Much appreciated!