Paul said:
I've created a custom field to calculate resources costs (I'm using the
Standard Rate column to record revenue as the resource is billed to a client)
but I can't work out how to add the column to a resource usage report so that
I can report revenue and costs by month.
Can anybody help
Thanks
Paul
Paul,
Simple answer - Project does not provide timescale data for spare
fields. The reason? A user can use spare fields for many things. It is
therefore impossible for Project to "know" how to timescale the data - a
simple linear spread may not be consistent with how the user has defined
the field.
Since you have explained what you are doing with the field, I have
another suggestion. Try using one of the alternate pay rate tables to
capture the client rate. Then "all" you need to do is to change the
active cost rate table which will then calculate the standard Cost field
at the client's rate and that data will be timescaled.
You can find the alternate pay rate tables by selecting a resource on
the Resource Sheet and going to Project/Resource Information/Cost tab.
To apply an alternate cost rate to all resources at one time, go to the
Resource Usage view and add the Cost Rate Table field. You can change
the cost rate table on each assignment line or you can apply a filter to
isolate only the assignment rows and then use a fill down.
As a side note, you CAN provide your own algorithm (e.g. linear spread)
for custom field data using VBA, but you will need to export it to
another application (e.g. Excel) to display it in a timescale fashion.
John
Project MVP
