Cost from Resource Plan

[wildo]

Is there a way or a field where I can get the total planned hours from a
Resource Plan? Then I could create a custom cost field and multiply total
hours by a standard rate for an approximate planned total labor cost. Of
course, to be more accurate, would be to get total hours per resource and
multiply it by each resource's rate, and total all those for a total cost.
But I'm sure that's asking too much.

I'm not a developer, so I normally find the database fields by searching
through Insert Column in Project Pro. But as far as I can tell, that doesn't
include the Resource Plan data, and there are no fields like this that appear
in Manage Views for Resource Plans.

Any ideas? Thanks.

 

[Dale Howard [MVP]]

wildo --

I would recommend you use a Data Analysis view for this purpose. There is a
Resource Plan Work total field included in the following OLAP cubes:

Assignment Non Timephased
Assignment Timephased
MSP_Portfolio_Analyzer
MSP_Project_Timesheet

Hope this helps.

 

[wildo]

Perfect - thanks.

wildo --

I would recommend you use a Data Analysis view for this purpose. There is a
Resource Plan Work total field included in the following OLAP cubes:

Assignment Non Timephased
Assignment Timephased
MSP_Portfolio_Analyzer
MSP_Project_Timesheet

Hope this helps.