Problems with custom fields

[Jim Reid]

I have the following local number fields and corresponding global project
number fields and the locals work and the globals don't. Anyone have any
ideas?

Project Number Field 1:
IIf(([Work Variance]=0) Or ([Baseline Work]=0),4,IIf(([Work
Variance]/[Baseline Work])>0.2,3,IIf(([Work Variance]/[Baseline
Work])>0.1,2,1)))

Project Number Field2:
IIf(([Duration Variance]=0) Or ([Baseline Duration]=0),4,IIf(([Duration
Variance]/[Baseline Duration])>0.2,3,IIf(([Duration Variance]/[Baseline
Duration])>0.1,2,1)))

Project Number Field3:
IIf(([Baseline Work]=0) Or ([% Work Complete]=0) Or ([Actual
Work]=0),4,IIf((([Baseline Work]*[% Work Complete])/[Actual
Work])>0.94,1,IIf((([Baseline Work]*[% Work Complete])/[Actual
Work])>0.74,2,3)))

Enterprise Global Project Number1rojWorkStatus
IIf(([Work Variance]=0) Or ([Baseline Work]=0),4,IIf(([Work
Variance]/[Baseline Work])>0.2,3,IIf(([Work Variance]/[Baseline
Work])>0.1,2,1)))

Enterprise Global Project Number2: ProjScheduleStatus
IIf(([Duration Variance]=0) Or ([Baseline Duration]=0),4,IIf(([Duration
Variance]/[Baseline Duration])>0.2,3,IIf(([Duration Variance]/[Baseline
Duration])>0.1,2,1)))

Enterprise Global Project Number3rojPerformanceIndex
IIf(([Baseline Work]=0) Or ([% Work Complete]=0) Or ([Actual
Work]=0),4,IIf((([Baseline Work]*[% Work Complete])/[Actual
Work])>0.94,1,IIf((([Baseline Work]*[% Work Complete])/[Actual
Work])>0.74,2,3)))

Graphical Indicators:
4=Black
3=Red
2=Yellow
1=Green

All Enterprise fields are Green
All Project Numbers are various and correct.