Creating Formulas in Enterprise Custom Fields

[Mark E]

Hello,

I have been creating 'basic' formulas using Enterprise Custom Project
Fields. I have been somewhat successful until now.

I have created a custom field called "Average Project Rate". I am using
the following formula:

[Enterprise Project Cost1]/[Baseline Work]

Please note: Enterprise Project Cost1 is a custom field called "Contract
Value". The PM will enter in the contract value when the schedule is first
created.

The sample I have setup will not calculate the above formula correctly:

Project1:
Enterprise Project Cost1 = $100.00
Baseline Work = 5 hrs
Contract Value = 0.33

I am not sure how it is calculating 0.33 within the "Contract Value" Field.
The value should be $20.00.

I was fooling around with the formula to try and understand how it works. I
tried [Contract Value] / [Baseline Cost] and this calculated correctly.

What am I missing or not doing???? Any feedback will be helpful!

Mark Etheridge
PMP

 

[Gérard Ducouret]

Hello Mark,
The internal calculation of Work in Project works with minutes.
So try the formula :
[Enterprise Project Cost1]/([Baseline Work]/60)

Hope this helps,

Gérard Ducouret

 

[Mark E]

Thank you very much Gerard, it worked!!

WOuld you by chance know of any good resources (ie: book, website) to help
me train or understand creating formulas ??

Thanks again!

Hello Mark,
The internal calculation of Work in Project works with minutes.
So try the formula :
[Enterprise Project Cost1]/([Baseline Work]/60)

Hope this helps,

Gérard Ducouret

Hello,

I have been creating 'basic' formulas using Enterprise Custom Project
Fields. I have been somewhat successful until now.

I have created a custom field called "Average Project Rate". I am using
the following formula:

[Enterprise Project Cost1]/[Baseline Work]

Please note: Enterprise Project Cost1 is a custom field called "Contract
Value". The PM will enter in the contract value when the schedule is first
created.

The sample I have setup will not calculate the above formula correctly:

Project1:
Enterprise Project Cost1 = $100.00
Baseline Work = 5 hrs
Contract Value = 0.33

I am not sure how it is calculating 0.33 within the "Contract Value" Field.
The value should be $20.00.

I was fooling around with the formula to try and understand how it

works.

I
tried [Contract Value] / [Baseline Cost] and this calculated correctly.

What am I missing or not doing???? Any feedback will be helpful!

Mark Etheridge
PMP