The LEN function is used to determined the character length of the given string in a cell.
len(string) : integer
The following example creates a column called ‘list’ and gives it the value ‘0123456789’. It then calculates the length of the string, which is 10.
gorrow 1,1,1 | CALC list '0123456789' | CALC length len(list)
len is not counting the length of the list and the following gives a length of 19:
gorrow 1,1,1 | CALC list '0,1,2,3,4,5,6,7,8,9' | CALC length len(list)
The length calculate is based on the contents of the cell, not the expression itself so the following gives a length of 2:
gorrow 1,1,1 | CALC list 1+2+3+4 | CALC length len(list)