Custom field formulas

[Steve]

I'm trying to figure out the correct formula to use with custom fields so
that I can calculate an internal resource cost per task, based on the work
assigned for that task.

For example, my resource is set up with a standard rate of $100 p/h. I have
an internal cost of $50 p/h which means my margin every hour is $50. I have
created a custom Internal Cost field [Cost1] within the resource sheet at $50
and have now created a second custom field [Cost2] called internal cost per
task.

The internal cost per task field uses the formula [Cost1]*[Work]

Whilst testing I have set the work at 10 hours for the task which means that
my resource cost should be $500 but [Cost2] calculated field is returning
$30,000 ???!?!

Can anyone shed light on why this is happening?

 

[Mike Mahoney]

I'm trying to figure out the correct formula to use with custom fields so
that I can calculate an internal resource cost per task, based on the work
assigned for that task.

For example, my resource is set up with a standard rate of $100 p/h. I have
an internal cost of $50 p/h which means my margin every hour is $50. I have
created a custom Internal Cost field [Cost1] within the resource sheet at $50
and have now created a second custom field [Cost2] called internal cost per
task.

The internal cost per task field uses the formula [Cost1]*[Work]

Whilst testing I have set the work at 10 hours for the task which means that
my resource cost should be $500 but [Cost2] calculated field is returning
$30,000 ???!?!

Can anyone shed light on why this is happening?

= 10 x 50 x 60 (minutes)

Mike

 

[Paul Conroy]

Not sure how this is being calculated !

You could get the value you wants by creating a Resource Cost field using
the formula [COST]/2

 

[Dale Howard [MVP]]

Steve --

Project Server stores all Work in minutes. Therefore, your formula should
be:

[Cost1] * [Work]/60

Hope this helps.