I'd like to setup a pivot table field that counts the number of characters in a given field. LEN([field name]) only returns 1 for every row.
Can't be done (sorry!), text values in calculated fields are treated as 0 automatically.
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
2 years ago