CathrynBSC said:
I want to display the internal costs and external costs in separate columns
in my task view. Can anybody suggest a method of using formulas to only
display costs that belong to a specific resource group?
Cathryn,
There are several "task" views. I will assume you mean Gantt Chart since
it is the default task view. Depending on your file structure there are
a few different ways to show cost for specific resource groups. If there
is only one resource group per task then a formula should work fine. If
there are only a limited number of resource groups (20 or less) then you
can use a spare flag field to identify each group. Then create one or
more custom cost fields that test for the appropriate flag to capture
the Cost field.
You could also use the Resource Usage view instead of a Task view. That
pretty much segregates out the cost by itself.
However, if you really want to have the information show on the Gantt
Chart and you don't like the idea of setting flags for each resource
group or there is more than one resource group assigned to each task, a
VBA macro can segregate out costs however you want and put the
information into whatever field you want.
Hope this helps.
John
Project MVP
