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