2 Replies Latest reply on Apr 14, 2009 12:37 PM by Jade

    Help with a calculation "get"

    underdog.com

      Title

      Help with a calculation "get"

      Post

      What do I need to place in this calculation, the field I want to use is called position#, however the employees position number is 6 digits long and I only want to use the last 3 

       

      Let (

      p = GetAsNumber ( ???????? ) ;

      Case(
      p < 100 ; "Administration";
      p < 300 ; "Project Development/Planning";
      p < 400 ; "Engineering Services";
      p < 500 ; "Right of Way";
      p < 600 ; "Construction";
      p < 800 ; "Maintenance";
      Other )

      )