Hi
this should be simple but i am stuck
A
A
A
B
B
Whats the formula for a rollup in a linked table to have "3A, 2B" as a result?
thx!
:M:
Solved
Rollup Count
+10Best answer by Alexey_Gusev
Hi,
I think it's smth like LEN(Field)-LEN(SUBSTITUTE(Field,'A','')) & 'A'
same for B, C etc
but instead of Field should be ARRAYJOIN(Field) or CONCATENATE(Field)
or (values) instead of (Field)
and if your A, B are words longer than 1 char, you should divide on it's LEN
if you have many letters, it's wise to put them all in a vertical list and use a formula to create a formula.
Note: hardcoding values in formula is a bad idea sometimes. If you create new linked field to a new table and copy this column, and add Count field in new table, you get pivot table close to your desired result
+25Hi,
I think it's smth like LEN(Field)-LEN(SUBSTITUTE(Field,'A','')) & 'A'
same for B, C etc
but instead of Field should be ARRAYJOIN(Field) or CONCATENATE(Field)
or (values) instead of (Field)
and if your A, B are words longer than 1 char, you should divide on it's LEN
if you have many letters, it's wise to put them all in a vertical list and use a formula to create a formula.
Note: hardcoding values in formula is a bad idea sometimes. If you create new linked field to a new table and copy this column, and add Count field in new table, you get pivot table close to your desired result
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.