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.

link|improve this question
returns 1 what for every row? – soandos Jan 24 at 18:54
I agree that SUM of LEN(fieldname) returns 1 on every row. – mtone Jan 24 at 19:39
May have to do with calculated fields interpreting content as values prior to performing the calculation. – mtone Jan 24 at 19:47
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.