Hi there, I have a project where I want to track both cost and price within the task view Gantt chart. To explain a little more, each of my resources in the resource sheet has two rates, a standard rate, and then a sell rate which I have put into the custom field "Cost1".
On my Gantt chart view, I then assign resources and can see the cost of the task in the actual cost field. I would also like to be able to see the "actual price" field which is calculated using the same hours and utilisation but multiplied by the sell rate in the resource "Cost1" field. Does anyone know how I might be able to do this?
Thanks,
Nick
Try(click) the following link to see if it helps.
Enter costs for MSP resources
Nick,
Welcome to PP. I don't know of a good way to do this using formulas only (i.e. without vba). The problem is that work, rates, and costs are fully integrated between tasks and resources through their assignments, but custom fields (e.g. your resource Cost1) cannot carry formulas through the assignments.
A vba routine would be pretty straightforward, though not trivial. (You'd essentially loop through the assignments for each task, do the math on the resource side, and aggregate the results to the custom task field.)
You might want to post on answers.microsoft.com or technet.microsoft.com, where there's more experience tailored to this kind of question.
Good luck, tom
[Belay that - just saw that John gave some good advice to you over on Technet - i.e. using the cost rate table. I imagine that's probably the way to go.]