AnsweredAssumed Answered

calculation combining Left and Case statements

Question asked by kilbot on Mar 16, 2011
Latest reply on Mar 16, 2011 by philmodjunk

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

Outcomes