### Title

Limiting length of list values

### Post

I have calculation that returns a list of values from a related field. The number of list values, as well as the length of each list value, varies. I would like to return a list where each value is limited to a certain amount of characters. I can figure out how to do this with a script (using a loop), but is there a way to do this within a calculation?

Example:

List =

123456789

12345

1234567

New List =

123

123

123

Thanks!

Michael

"I have calculation that returns a list of values from a related field"I suppose that your calculation is something like: List ( YourTable::YourField )

If so, you'll need:

1) to define a new calculation field in YourTable with calc:

Left ( YourField ; 3 )2) to change your list calculation to

List ( YourTable::YourNEWField )