Help

Rollup Count

Topic Labels: Formulas
Solved
Jump to Solution
539 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Miroslav_Tunjic
6 - Interface Innovator
6 - Interface Innovator

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:

  

 

 

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

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

See Solution in Thread

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

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

Miroslav_Tunjic
6 - Interface Innovator
6 - Interface Innovator

Thx Alexey!

Sorry for the late reply, did what you suggested and helped!

Thank You!