Enterprise Custom Field Formula not calculating

  • Thread starter Conrad Santiago
  • Start date
C

Conrad Santiago

I created this formula for this field, Custom EnterpriseCost1:

iif([Work]=0, 0,[Cost]/[Work]*60)

When I open up a project and display this field, all the cells display zero,
"0.00". (Many of the tasks in the project have non-zero Work and Cost
values.)

When I create the same formula in a non-Enterprise field, Custom Cost1, it
calculates the values correctly.

How do I correct this so that the values calculate correctly in the Custom
EnterpriseCost1 field?
 
D

Dale Howard [MVP]

Conrad --

What happens if you press the F9 function key to recalculate the project?
Does the formula calculate correctly? Let us know.
 
C

Conrad Santiago

No. I pressed the F9 key and the values remain zero.


Dale Howard said:
Conrad --

What happens if you press the F9 function key to recalculate the project?
Does the formula calculate correctly? Let us know.




Conrad Santiago said:
I created this formula for this field, Custom EnterpriseCost1:

iif([Work]=0, 0,[Cost]/[Work]*60)

When I open up a project and display this field, all the cells display
zero, "0.00". (Many of the tasks in the project have non-zero Work and
Cost values.)

When I create the same formula in a non-Enterprise field, Custom Cost1,
it calculates the values correctly.

How do I correct this so that the values calculate correctly in the
Custom EnterpriseCost1 field?
Click to expand...
Click to expand...
 
D

Dale Howard [MVP]

Conrad --

Strangely enough, I added the formula to my Enterprise Global file and the
formula calclates just fine. I'm not sure what might be causing your
problem. Sorry.




Conrad Santiago said:
No. I pressed the F9 key and the values remain zero.


Dale Howard said:
Conrad --

What happens if you press the F9 function key to recalculate the project?
Does the formula calculate correctly? Let us know.




Conrad Santiago said:
I created this formula for this field, Custom EnterpriseCost1:

iif([Work]=0, 0,[Cost]/[Work]*60)

When I open up a project and display this field, all the cells display
zero, "0.00". (Many of the tasks in the project have non-zero Work and
Cost values.)

When I create the same formula in a non-Enterprise field, Custom Cost1,
it calculates the values correctly.

How do I correct this so that the values calculate correctly in the
Custom EnterpriseCost1 field?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Need some PWA help 0
How to use/create code in MS Word to calculate age? 0
'Custom Enterprise Field' 1
Display weeks from a Milestone 0
2016 Project, adding a workday to custom field 0
Problem with Enterprise Custom field 4
#ERROR Message in Calculated Field 3

Top