Customized field formula vs Standard Rates

[Olivier P.]

I have an issue while trying to calculate the following: I would like to
calculate the field Cost like this = Work x Standard rate (as defined in the
Resource Sheet) only if field Text1 = Yes.

- At first sight, we can not apply a formula (a condition Iif) to the Cost
field (except on the Cost(x) fields where x=1-10). Unfortunate...

- I would then, to overcome this limitation, customize the field Cost1 in
order to be able to define it like this = IIf([Text1]="Yes", [Cost]* ... ,0).
This works but only with a given amount, but I would like to use the Standard
Rates that are defined in the Resource Sheet. How can I call this 'built-in'
MSP variable?

- Also last issue (I can not understand this): if I try to calculate my
field Cost1, I get it automatically multiplied by 60 (per hour or 480 per
day)... For instance, I defined Cost1 = Work. I enter 1 hour in Work, I get
Cost1 = 80 ... ? Where does this comes from? I fixed it by dividing by 80 but
this not a solution of course.

Thank for your help, I tried to be concised and clear but I know this might
not be the case, so do not hesitate to ask me for explanations if needed.

Thanks!

 

[Dytham]

I don't see how you can multiply these as Work is a Task field and Standard
Rate that of a Resource ( and can be one to many relationship).

Work is held internally by Project in minutes, hence the need for the
division.

 

[Olivier P.]

Dear Dytham,

Why? Each task has a resource which has a standard rate defined and assigned
through the Cost rate table (Resource Usage / Assignment Information)

I do not really understand the limitation of accessing variables from
different "environments" (Task, Resource, ...) since the Cost field, by
default, uses information from the Task (# of hours/days) with information
from Resource (standard rates).

Thank you

I don't see how you can multiply these as Work is a Task field and Standard
Rate that of a Resource ( and can be one to many relationship).

Work is held internally by Project in minutes, hence the need for the
division.

I have an issue while trying to calculate the following: I would like to
calculate the field Cost like this = Work x Standard rate (as defined in the
Resource Sheet) only if field Text1 = Yes.

- At first sight, we can not apply a formula (a condition Iif) to the Cost
field (except on the Cost(x) fields where x=1-10). Unfortunate...

- I would then, to overcome this limitation, customize the field Cost1 in
order to be able to define it like this = IIf([Text1]="Yes", [Cost]* ... ,0).
This works but only with a given amount, but I would like to use the Standard
Rates that are defined in the Resource Sheet. How can I call this 'built-in'
MSP variable?

- Also last issue (I can not understand this): if I try to calculate my
field Cost1, I get it automatically multiplied by 60 (per hour or 480 per
day)... For instance, I defined Cost1 = Work. I enter 1 hour in Work, I get
Cost1 = 80 ... ? Where does this comes from? I fixed it by dividing by 80 but
this not a solution of course.

Thank for your help, I tried to be concised and clear but I know this might
not be the case, so do not hesitate to ask me for explanations if needed.

Thanks!

 

[Olivier P.]

I just had to think twice about it...

The way to solve it is to put the condition (If Text1 = Yes) on the Cost1
field like this: Iif ([Text1]="Yes"; [Cost]; 0)

That was maybe too easy to see it

 

[Jan De Messemaeker]

Hi,

Tasks may have many "assignments" - not resources
Your statement "every task has a resource" is not always accurate
In VBA from an assignment you can indeed access both the task.text1 and the
resource's rates.
Assignment customs fields cannot hold formaulas.
Tasks formulas cannot access resoruce fields.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Dear Dytham,

Why? Each task has a resource which has a standard rate defined and
assigned
through the Cost rate table (Resource Usage / Assignment Information)

I do not really understand the limitation of accessing variables from
different "environments" (Task, Resource, ...) since the Cost field, by
default, uses information from the Task (# of hours/days) with information
from Resource (standard rates).

Thank you

I don't see how you can multiply these as Work is a Task field and
Standard
Rate that of a Resource ( and can be one to many relationship).

Work is held internally by Project in minutes, hence the need for the
division.

I have an issue while trying to calculate the following: I would like
to
calculate the field Cost like this = Work x Standard rate (as defined
in the
Resource Sheet) only if field Text1 = Yes.

- At first sight, we can not apply a formula (a condition Iif) to the
Cost
field (except on the Cost(x) fields where x=1-10). Unfortunate...

- I would then, to overcome this limitation, customize the field Cost1
in
order to be able to define it like this = IIf([Text1]="Yes", [Cost]*
... ,0).
This works but only with a given amount, but I would like to use the
Standard
Rates that are defined in the Resource Sheet. How can I call this
'built-in'
MSP variable?

- Also last issue (I can not understand this): if I try to calculate my
field Cost1, I get it automatically multiplied by 60 (per hour or 480
per
day)... For instance, I defined Cost1 = Work. I enter 1 hour in Work, I
get
Cost1 = 80 ... ? Where does this comes from? I fixed it by dividing by
80 but
this not a solution of course.

Thank for your help, I tried to be concised and clear but I know this
might
not be the case, so do not hesitate to ask me for explanations if
needed.

Thanks!