0
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.
0
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.
0
Can't be done (sorry!), text values in calculated fields are treated as 0
automatically.
returns 1 what for every row? – soandos – 2012-01-24T18:54:44.893
I agree that SUM of LEN(fieldname) returns 1 on every row. – mtone – 2012-01-24T19:39:27.037
May have to do with calculated fields interpreting content as values prior to performing the calculation. – mtone – 2012-01-24T19:47:04.357