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

S

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?
 
D

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.
 
M

mike.mahoney

No, hitting F9 doesn't fix the problem.

Sarah
--
Sarah



sjk75 said:
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?
 
S

sjk75

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


No, hitting F9 doesn't fix the problem.

Sarah
--
Sarah



sjk75 said:
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?
 

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

Top