Skip to main content
Solved

Custom Time Phased data field based on Staffing Requests PLUS Project Assignments

  • July 19, 2024
  • 2 replies
  • 58 views

stefan.kolip
Gold Active Participant
Forum|alt.badge.img

To achieve some PS forecasting, we were wanting to make a custom field that would take the Time Phase Data of Staffing Requests + Project Assignments for a Project and multiply the Sum of the Hours with a calculated dollar value. We are not seeing a way to sum both Staffing Requests and Project Assignments in a Custom Field. Any advice on how we can achieve this?

Best answer by Limori

Hi Stefan

You might be able to achieve this by creating custom fields of type ‘Relation Summary’ whereby you sum up all Requested Work from Staff Time Phased Data 

 

and Project Assignment from Labor Time Phased Data:

 

You would then need to create a 3rd custom field to sum up those two value and a 4th to calculate the US$ value.

This topic has been closed for replies.

2 replies

Limori
Planview Falcons
Forum|alt.badge.img+4
  • Planview Falcons
  • Answer
  • December 24, 2024

Hi Stefan

You might be able to achieve this by creating custom fields of type ‘Relation Summary’ whereby you sum up all Requested Work from Staff Time Phased Data 

 

and Project Assignment from Labor Time Phased Data:

 

You would then need to create a 3rd custom field to sum up those two value and a 4th to calculate the US$ value.


stefan.kolip
Gold Active Participant
Forum|alt.badge.img
  • Author
  • Gold Active Participant
  • January 13, 2025

Thanks Limor for the response. Appreciated.
I will discuss with our BuizAdmin - but I learned that relation summary fields are pretty “costly” as rare.

Anyhow, the suggestion sounds great!