Calculating Actual Work

[RandyK]

I am trying to multiply actual work (hours) by a value chosen by the PM.
I’ve created a custom “Enterprise Number†field that contains a drop-down
list of numeric values. I then created calculated field (Enterprise
Number2) that multiplies this value times the number of hours shown in
“Actual Workâ€. My results are “zeroâ€. What am I doing wrong? I need to
roll these value up to the summary task level and to the project summary
task as well.

 

[Jonathan Sofer]

This might be silly question but are you making sure that your task has
actual work on it? It has to be durationed, resourced and then "progressed"
before you get any actual work data.

Also, make sure your two fields are both task level number fields. Your
formula field should be [Enterprise Number1]*([Actual Work]/60) and the
rollup should be set to "Sum"

Jonathan Sofer

 

[RandyK]

Hi Jon,

Yes - even though I am using Project Server, I manually added actual work to
the tasks. I didn't know it had to have a resource assigned for this to
work. Also, what is meant by "Roll up set to Sum".

I think you are sterring me in the right direction...thanks! Let me know
about the above questions!

--
Thanks much!
Randy

This might be silly question but are you making sure that your task has
actual work on it? It has to be durationed, resourced and then "progressed"
before you get any actual work data.

Also, make sure your two fields are both task level number fields. Your
formula field should be [Enterprise Number1]*([Actual Work]/60) and the
rollup should be set to "Sum"

Jonathan Sofer

 

[Jonathan Sofer]

Well, technically, you don't have to have resources assigned to a task but
it is best practice to assign the resources working on a task with
appropriate amounts of effort. Your formula of [Number1]*[Actual Work]/60
should work if you have Number1 set at the task to something other than 0
and you have some actual work on the task.

The Roll up to sum means that when you are defining your formula field, you
want to set the calculation for summary level to rollup as a Sum.

Jonathan

Hi Jon,

Yes - even though I am using Project Server, I manually added actual work
to
the tasks. I didn't know it had to have a resource assigned for this to
work. Also, what is meant by "Roll up set to Sum".

I think you are sterring me in the right direction...thanks! Let me know
about the above questions!

--
Thanks much!
Randy

This might be silly question but are you making sure that your task has
actual work on it? It has to be durationed, resourced and then
"progressed"
before you get any actual work data.

Also, make sure your two fields are both task level number fields. Your
formula field should be [Enterprise Number1]*([Actual Work]/60) and the
rollup should be set to "Sum"

Jonathan Sofer

I am trying to multiply actual work (hours) by a value chosen by the PM.
I've created a custom "Enterprise Number" field that contains a
drop-down
list of numeric values. I then created calculated field (Enterprise
Number2) that multiplies this value times the number of hours shown in
"Actual Work". My results are "zero". What am I doing wrong? I
need
to
roll these value up to the summary task level and to the project
summary
task as well.