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?
Solved
Custom Time Phased data field based on Staffing Requests PLUS Project Assignments
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.
+4Hi 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.
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!
Reply
Most helpful members this week
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview Adminor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com