Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Calculated Field or Fusion Challenge: Actual Hours by Year by Distinct Project

Avatar

Level 4

Tapping on the WF hive mind here...I'm looking to understand if:

 

Can you create a calculated field that pulls in the sum of hours based on year? (I would think hour entry date contains would work....but tying that into actualhoursworked I can't see how to filter a contains. -I thought of a 'hours this year' filter on a field...but again....still a novice here.

 

or

 

Can you use Fusion to 'feed' a field onto a project form that sums up actual hours logged against that project by entry year?

 

Use case: Currently data exported into PowerBI so the only way to get the breakdown by year is running the report once a week and then going from there. (or, creating a direct link to Workfront report into a PowerBI refresh which not sure can be done)

 

 

1 Reply