Displaying Repeating Field Values

[Corey-Troy]

I have a repeating Number field[24].

I now want to set another field to display all the values in the repeating field, but only those that have a value in them.

I want each of the values separated by a ", " for ease of viewing.

I will need to set the field long enough in size to allow for the possibility of 24 separate numerical values.

And allow for the comma between each value also.

Would the field need to be set to a Number field or a Text field, as it includes comma's ?

How can i achieve this?

[comment]

You could use =

Substitute ( List ( YourRepeatingField ) ; ¶ ; ", " )

The result of the calculation is Text. All the usual warnings about using repeating fields apply.

[Corey-Troy]

TY