MS Project - Mixed Resource Cost
MS Project - Mixed Resource Cost
(OP)
I have a large, muilt task project I am managing. I am generally familiar with MS Project and fairly proficient. I have all of my labor and material resources entered and assigned. The porject correctly calculates the cost based on what / who I have assigned.
I am now looking to add custom cost columns that will pull out just the materials cost or labor cost of a particular task. Generally, a simple if statement works fine for this
IIf([Resource Group]="L",[Cost],0)
However, if the task has both a labor and materials resource entered I can not find a formula that will give me any answer other than "0". I simply want to pull out what is labor in one column, and what is materials in another.
Is this possible in MS Project? It should be, without creating additional tasks and splitting resources.
I am now looking to add custom cost columns that will pull out just the materials cost or labor cost of a particular task. Generally, a simple if statement works fine for this
IIf([Resource Group]="L",[Cost],0)
However, if the task has both a labor and materials resource entered I can not find a formula that will give me any answer other than "0". I simply want to pull out what is labor in one column, and what is materials in another.
Is this possible in MS Project? It should be, without creating additional tasks and splitting resources.
Talk To Other Members