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.]
Member for
21 years 8 monthsTry(click) the following link
Try(click) the following link to see if it helps.
Enter costs for MSP resources
Member for
18 years 11 monthsNick,Welcome to PP. I don't
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.]