can i separate labor cost vs material cost on one task?

[R.Scott Fleming]

Is there a way that while in the Gantt view using the cost table and creating
a custom column called COST1, that when customizing the column using the
custom attributes and selecting formula, that I can create a filter that only
would display the cost for material or labor (depending on what syntax is
used)?

What I have tried so far is the following(which seems to work):

First, while in the resource sheet I used the TYPE column and inserted the
name “Supplier†for material resources and leave a blank in it for labor
resources.

Then I created the following filter for COST1 column back in the Gantt view:
IIf([Resource Group]<>"Supplier",[Cost]*(1.5),0)
When using this, if the task had a labor resource assigned, the value in the
COST1 field would take the labor cost and multiply it by 1.5

I also created a COST2 column and created the following filter:
IIf([Resource Group]="Supplier",[Cost],0)
When using this, if the task had a material resource assigned, the value in
the COST2 field would just be the COST amount.

This seems to work OK, but only works if the task has either material or
labor assigned. It does not work if the task has both labor & material
assigned.….

Is there a way this can be done?

 

[JulieS]

To build on Trevor's reply -- show the Task Usage view and add the
Cost field. Create a custom group to group first by Name (Task
field) and then by Resource Type (assignment). You'll now have two
grouping rows underneath each task -- showing total cost for work
resources and total cost for material resources.

You must do this in the Task Usage view as you are trying to
separate cost based upon assignment information -- not task
information.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project