AnsweredAssumed Answered

Help with Case calculation

Question asked by Thicks on Mar 3, 2009
Latest reply on Mar 3, 2009 by raybaudi

Title

Help with Case calculation

Post

Here is the calculation that I have written for when a position number lands betwwen a certain range that it calculates the department.

 

Case ( Position#Second3Digits= 001...099; "Administration";
Position#Second3Digits= 100...289; "Project Development/Planning";
 Position#Second3Digits= 300...349; "Engineering Services";
 Position#Second3Digits= 400...499; "Right of Way";
 Position#Second3Digits= 500...599; "Construction";
 Position#Second3Digits= 600...799; "Maintenance"; Other)

 

However it tells me that I cannot use 001...099

 

How can I make it for the range of numbers I have shown?

 

Thanks



Outcomes