How to count a specific letter in a column?

[Elizes_Low1]

There is a column where a string of letters like “S,S,L,L,M,M” to specify sizes. How can I count in this string, how many S and other sizes? I tried getting it be a linked record, but it summarizes itself to be S, M and L - ignoring the duplicates. Therefore, I cannot use the rollup function.

[Elias_Gomez_Sai]

You can use this technique:

Counting linked records in the same table Ask the community

You can do this: Transform Linked Records into a String: ARRAYJOIN(LR) Get length of String: LEN(String) Remove the commas and get the length of the String: LEN(SUBSTITUTE(String,',' , '')) The difference is the number of commas, that is the number of Linked Records minus 1 Sum 1 to the commas number: Length - {No commas} + 1. Oh, I have wrapped the last step into a IF() to check if there are linked records so we don’t get 1 when they are not: IF({Linked Records}, Length - {No commas} + 1,…