R
Riko Wichmann
Dear all,
in our project plans we plan Capital Investment als Material Resource
and Work Resource (big surprise). Of course, it is of interest who much
capital investment is planned for individual projects and (summary
tasks). For that purpose, I'd like to define a custom cost field, which
such sums the costs for material costs.
What partially works is the following. All capital investment resources
belong to the Resource Group "Cap". Then I define a filed "Invest" with
the following formula:
IIf([Resource Group]="Cap";[Cost];0)
However, that only seems to work as long as I don't mix work and
material resource assignment to a task. If I have task which have only
material resource or work resources (but not both) assigned, bost costs
are separated correctly. If I have a task which uses both resource
types, the total cost is used (which I guess makes sense from the above
definition, if you assume the If statement actually checks, if the term
"Cap" in contained in the resource group field).
But it is almost impossible to prevent all people in the project from
using mixed resource assignments.
Is there a more clever way on separating material and personnel costs?
Thanks,
Riko
in our project plans we plan Capital Investment als Material Resource
and Work Resource (big surprise). Of course, it is of interest who much
capital investment is planned for individual projects and (summary
tasks). For that purpose, I'd like to define a custom cost field, which
such sums the costs for material costs.
What partially works is the following. All capital investment resources
belong to the Resource Group "Cap". Then I define a filed "Invest" with
the following formula:
IIf([Resource Group]="Cap";[Cost];0)
However, that only seems to work as long as I don't mix work and
material resource assignment to a task. If I have task which have only
material resource or work resources (but not both) assigned, bost costs
are separated correctly. If I have a task which uses both resource
types, the total cost is used (which I guess makes sense from the above
definition, if you assume the If statement actually checks, if the term
"Cap" in contained in the resource group field).
But it is almost impossible to prevent all people in the project from
using mixed resource assignments.
Is there a more clever way on separating material and personnel costs?
Thanks,
Riko