Enterprise Formula Errors - works on some files, but not all on se

[sjk75]

I have a set of enterprise Number formulas that are working in all but one
file. As these formulas are in an enterprise field, I can't figure out why I
am getting an error in just this one file. Here are my formulas:

Enterprise Number19 = Number (copied from % complete field on a specific time)
Enterprise Number21 = ([Enterprise Number19]*[Baseline Work]/60)*0.01
Enterprise Number22 = iif([Enterprise Number21]=0,0,(([Enterprise
Number21]/([Baseline Work]/60)*100)))

Under the task and group summry row calculation, I want to sum on Enterprise
Number21 and and use the formula on Enterprise Number22.

I am getting #ERROR in both Enterprise Number21 and Enterprise Number22
fields.

These formulas work in local fields.

Anyone have any suggestions on troubleshooting my project file?

 

[Dale Howard [MVP]]

Sarah --

If you open one of the troublesome projects and press the F9 function key to
recalculate the project, does this resolve the issue? Let us know.

 

[sjk75]

No, hitting F9 doesn't fix the problem.

Sarah

 

[mike.mahoney]

No, hitting F9 doesn't fix the problem.

Sarah
--
Sarah

I have a set of enterprise Number formulas that are working in all but one
file. As these formulas are in an enterprise field, I can't figure out why I
am getting an error in just this one file. Here are my formulas:

Enterprise Number19 = Number (copied from % complete field on a specific time)
Enterprise Number21 = ([Enterprise Number19]*[Baseline Work]/60)*0.01
Enterprise Number22 = iif([Enterprise Number21]=0,0,(([Enterprise
Number21]/([Baseline Work]/60)*100)))

Under the task and group summry row calculation, I want to sum on Enterprise
Number21 and and use the formula on Enterprise Number22.

I am getting #ERROR in both Enterprise Number21 and Enterprise Number22
fields.

These formulas work in local fields.

Anyone have any suggestions on troubleshooting my project file?

- Show quoted text -

Have you set a baseline in this plan?

 

[sjk75]

Yes, there is a baseline set in this file.
--
Sarah

No, hitting F9 doesn't fix the problem.

Sarah
--
Sarah

I have a set of enterprise Number formulas that are working in all but one
file. As these formulas are in an enterprise field, I can't figure out why I
am getting an error in just this one file. Here are my formulas:

Enterprise Number19 = Number (copied from % complete field on a specific time)
Enterprise Number21 = ([Enterprise Number19]*[Baseline Work]/60)*0.01
Enterprise Number22 = iif([Enterprise Number21]=0,0,(([Enterprise
Number21]/([Baseline Work]/60)*100)))

Under the task and group summry row calculation, I want to sum on Enterprise
Number21 and and use the formula on Enterprise Number22.

I am getting #ERROR in both Enterprise Number21 and Enterprise Number22
fields.

These formulas work in local fields.

Anyone have any suggestions on troubleshooting my project file?

- Show quoted text -

Have you set a baseline in this plan?