MS Project Enterprise Formula Function -- HELP PLEASE **

[Erin]

Is there a character limit as in Excel for this function? I have a long
complicated forumula I'm trying to compute within this function and it's only
working for some instead of all. I have been opening up the projects,
clicking F8 to re-compute and some still ERRORs out and gives me zeros on
project web access views. It's erroring out when the answer is found at the
end of the formula like it's got a character limit. the formula is pasted
below. Does anyone know a way to get this to work all the time instead of
some of the time within project enterprise number fields?

Thanks in advance -- (e-mail address removed)

****
IIf([Enterprise Project Text33]="Deleted",600,IIf([Enterprise Project
Text33]="Completed",600,IIf([Enterprise Project
Text33]="Duplicate",600,IIf([Enterprise Project
Text24]="Emergency",[Enterprise Project Number2],IIf([Enterprise Project
Text24]="Routine",200+[Enterprise Project Number2],[Enterprise Project
Number2]+(IIf([Enterprise Project Date2]="NA",IIf([Enterprise Project
Date3]="NA",100,IIf(DateValue([Enterprise Project
Date3])>(NOW()+1360),400,IIf(DateValue([Enterprise Project
Date3])>(NOW()+1095),300,IIf(DateValue([Enterprise Project
Date3])>(NOW()+730),200,100)))),IIf(DateValue([Enterprise Project
Date2])>(NOW()+1360),400,IIf(DateValue([Enterprise Project
Date2])>(NOW()+1095),300,IIf(DateValue([Enterprise Project
Date2])>(NOW()+730),200,100))))))))))

 

[mike.mahoney]

Is there a character limit as in Excel for this function? I have a long
complicated forumula I'm trying to compute within this function and it's only
working for some instead of all. I have been opening up the projects,
clicking F8 to re-compute and some still ERRORs out and gives me zeros on
project web access views. It's erroring out when the answer is found at the
end of the formula like it's got a character limit. the formula is pasted
below. Does anyone know a way to get this to work all the time instead of
some of the time within project enterprise number fields?

Thanks in advance -- (e-mail address removed)

****
IIf([Enterprise Project Text33]="Deleted",600,IIf([Enterprise Project
Text33]="Completed",600,IIf([Enterprise Project
Text33]="Duplicate",600,IIf([Enterprise Project
Text24]="Emergency",[Enterprise Project Number2],IIf([Enterprise Project
Text24]="Routine",200+[Enterprise Project Number2],[Enterprise Project
Number2]+(IIf([Enterprise Project Date2]="NA",IIf([Enterprise Project
Date3]="NA",100,IIf(DateValue([Enterprise Project
Date3])>(NOW()+1360),400,IIf(DateValue([Enterprise Project
Date3])>(NOW()+1095),300,IIf(DateValue([Enterprise Project
Date3])>(NOW()+730),200,100)))),IIf(DateValue([Enterprise Project
Date2])>(NOW()+1360),400,IIf(DateValue([Enterprise Project
Date2])>(NOW()+1095),300,IIf(DateValue([Enterprise Project
Date2])>(NOW()+730),200,100))))))))))

Presumably you are on pS 2003. Has it been service packed?

Mike

 

[Erin]

I believe I'm using PS2k, with MS Project 2k3...and yes -- it's service packed.

Is there a character limit as in Excel for this function? I have a long
complicated forumula I'm trying to compute within this function and it's only
working for some instead of all. I have been opening up the projects,
clicking F8 to re-compute and some still ERRORs out and gives me zeros on
project web access views. It's erroring out when the answer is found at the
end of the formula like it's got a character limit. the formula is pasted
below. Does anyone know a way to get this to work all the time instead of
some of the time within project enterprise number fields?

Thanks in advance -- (e-mail address removed)

****
IIf([Enterprise Project Text33]="Deleted",600,IIf([Enterprise Project
Text33]="Completed",600,IIf([Enterprise Project
Text33]="Duplicate",600,IIf([Enterprise Project
Text24]="Emergency",[Enterprise Project Number2],IIf([Enterprise Project
Text24]="Routine",200+[Enterprise Project Number2],[Enterprise Project
Number2]+(IIf([Enterprise Project Date2]="NA",IIf([Enterprise Project
Date3]="NA",100,IIf(DateValue([Enterprise Project
Date3])>(NOW()+1360),400,IIf(DateValue([Enterprise Project
Date3])>(NOW()+1095),300,IIf(DateValue([Enterprise Project
Date3])>(NOW()+730),200,100)))),IIf(DateValue([Enterprise Project
Date2])>(NOW()+1360),400,IIf(DateValue([Enterprise Project
Date2])>(NOW()+1095),300,IIf(DateValue([Enterprise Project
Date2])>(NOW()+730),200,100))))))))))

Presumably you are on pS 2003. Has it been service packed?

Mike