Custom fields & formula calcualtion problem

[Barb PMO]

My company uses Project Pro 2003 and Project Server

I've added 2 Enterprise custom fields, Enterprise Project Cost1 (for the
Project Sale Price) and a field for a calculated value, Enterprise Project
Cost2 (used to calculate the Price per Hour) The formula is Enterprise
Project Cost2 = [Sale Price] / [Baseline Work].

The problem is I'm getting 2 differernt types of weird results.

1) For a project with a sale price of 138,000.00 and Baseline work of 920h,
my expected results are 150.00. Actual results = 2.5
2) For a project with a sale price of 27,035.00 and Baseline work of
213.33h, my expected results are 127.00. Actual results = 211.21

I don't use multiple baselines, and all project sale prices are entered in
Project information as (ex. 138,000.00)

Any ideas?

 

[Marc Soester]

The problem is usually caused by failing to convert the units correctly.
When you use work in a formula Project uses the value of MINUTES.

You will need to write a formular not based on hours but based on mintus.
Project Server alway uses Minutes.

The formular should look something like this:

Project Cost2 = [Sale Price] / [Baseline Work] * 60 .

Hope this helps

 

[Barb PMO]

Thank-you so much! It worked wonderfully.
--
Barb PMO

The problem is usually caused by failing to convert the units correctly.
When you use work in a formula Project uses the value of MINUTES.

You will need to write a formular not based on hours but based on mintus.
Project Server alway uses Minutes.

The formular should look something like this:

Project Cost2 = [Sale Price] / [Baseline Work] * 60 .

Hope this helps

--
Marc Soester
State Manager: EPM

My company uses Project Pro 2003 and Project Server

I've added 2 Enterprise custom fields, Enterprise Project Cost1 (for the
Project Sale Price) and a field for a calculated value, Enterprise Project
Cost2 (used to calculate the Price per Hour) The formula is Enterprise
Project Cost2 = [Sale Price] / [Baseline Work].

The problem is I'm getting 2 differernt types of weird results.

1) For a project with a sale price of 138,000.00 and Baseline work of 920h,
my expected results are 150.00. Actual results = 2.5
2) For a project with a sale price of 27,035.00 and Baseline work of
213.33h, my expected results are 127.00. Actual results = 211.21

I don't use multiple baselines, and all project sale prices are entered in
Project information as (ex. 138,000.00)

Any ideas?