Add a calculation to a report | Community
Skip to main content
J
Justin_Charles
Level 3
June 20, 2023
Solved

Add a calculation to a report

  • June 20, 2023
  • 1 reply
  • 988 views

Hello!  I have a project report with a column for actual hours.  I would like to add a column next to it that simply takes the actual hours and multiplies it by a dollar amount.  Can anyone help with the text code for that?

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

Hi Justin, try Actual Cost and also trying recalculating expressions not just finance. It may also take a couple refreshes or clearing your cache. As long as the role has $ associated and the role is associated with users, it should show. It may also not be a retroactive thing, it may only be for their hours logged moving forward.
More info on all this here - https://experienceleague.adobe.com/docs/workfront/using/manage-work/projects/project-finances/track-costs.html?lang=en#how-workfront-calculates-planned-budgeted-and-actual-costs

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
June 20, 2023

Hi, if you associate your users with a job role, and each job role has a billing rate associate it, you can add in a revenue or labor cost column into your hour report that shows you hours x $$ to get this natively without text mode...

If this helped you, please mark correct to help others : )
J
Justin_CharlesAuthor
Level 3
June 20, 2023

Thanks Madalyn - I would love to get this working.  I added a $ amount in cost per hour for one of our roles.  I also added a column for Actual Labor Cost on my project report, but the Actual Labor Cost is showing as $0.  When I go into Hours of a project, it is also showing $0 under Actual Cost next to all the hours logged by the users in that role.  I tried "Recalculating finance" to no avail.  Am I missing something?

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
June 20, 2023

Hi Justin, try Actual Cost and also trying recalculating expressions not just finance. It may also take a couple refreshes or clearing your cache. As long as the role has $ associated and the role is associated with users, it should show. It may also not be a retroactive thing, it may only be for their hours logged moving forward.
More info on all this here - https://experienceleague.adobe.com/docs/workfront/using/manage-work/projects/project-finances/track-costs.html?lang=en#how-workfront-calculates-planned-budgeted-and-actual-costs

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

Loading footer...