Calculating Custom fields

[Diane]

Using Project 2003
Created three custom fields; AAA, BBB, and CCC. AAA and
BBB are enterable fields using Number18 & 19. CCC's
formula is AAA/BBB*100. Instead of geting a calulated
amount for CCC, I get a zero (0). It is also enterable
and should not be.

Why is field CCC not calculating properly?

Thank you for your response.

 

[JulieS]

Hi Diane,

I assume the CCC field is also one of the custom Number
fields.
The formulas for CCC should be entered using the
customize fields command (Tools --> Customize --> Fields)
command. Under custom attributes, click the formula
button. Because you are referring to fields the formula
needs to be:
[Number18]/[Number19]*100

Field names need to be enclosed in square brackets. It
should now work fine. You should not be able to overwrite
the result in CCC.

Hope this helps.
Julie

 

[JackD]

On top of this, you may encounter problems when one calculated field refers
to another.
Imagine what happens when one calculates before the other.
I suggest that you write the formula for C so that it is independent of A
and B.
For example if:

A = [Finish]-[Start]
B = [Baseline Finish] - [Baseline Start]

then I'd write C so that:

C = 100*([Finish]-[Start])/([Baseline Finish] - [Baseline Start])

-Jack

Hi Diane,

I assume the CCC field is also one of the custom Number
fields.
The formulas for CCC should be entered using the
customize fields command (Tools --> Customize --> Fields)
command. Under custom attributes, click the formula
button. Because you are referring to fields the formula
needs to be:
[Number18]/[Number19]*100

Field names need to be enclosed in square brackets. It
should now work fine. You should not be able to overwrite
the result in CCC.

Hope this helps.
Julie

-----Original Message-----
Using Project 2003
Created three custom fields; AAA, BBB, and CCC. AAA and
BBB are enterable fields using Number18 & 19. CCC's
formula is AAA/BBB*100. Instead of geting a calulated
amount for CCC, I get a zero (0). It is also enterable
and should not be.

Why is field CCC not calculating properly?

Thank you for your response.
.