3 Replies Latest reply on Mar 16, 2011 11:09 AM by philmodjunk

    calculation combining Left and Case statements

    kilbot

      Title

      calculation combining Left and Case statements

      Post

      Left (text; numberof characters) and a

      Case(test; result)

      I have a number in a field 6132 and I want to get the left value = 6

      easy enough I use the LEFT function. But I want if the value is 6 the field to calculate "S"

      Final answer results as "S" for 6132

      Thanks