Sum of Two Columns in Issue report not working

Question

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 Answer

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-overview.html?lang=en

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/edit-text-mode-in-view.html?lang=en

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded