Hi there. I am working with a Rollup up field linking between a Series table and ID table. The ID table has a field called Episodes. What I am trying to work out is how do I display the number of episodes linked from the linked ID table and the count of each.

Example:

Episode Roll Up

9, 5, 3, 3

(so there are four ID records linked to the Series table and from the ID table’s Episode field there is 1 x ID from Ep 9, 1 x ID from Ep 5 and 2 x IDs from Ep 3)

What I would like to display either directly in the RollUp field or in a companion Calculation field is the following:

3: 2

5: 1

9: 1

(so I’d like to be able to order the Episode numbers as well to make it cleaner to view).

I have searched thru the Community posts but can’t find anything that addresses this particular query. Any help would be very much appreciated!