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