Help with SUBSTITUTE() expression

[MauriceWhelan]

Hi

I am using the following expression to get the [Pole Code] values in the screenshot attached and it works perfectly fine.
SUBSTITUTE(SELECT(Works_Orders_Master[Creosoted Code],[Charge Number] = [_THISROW].[Charge Number]) , " , " , "
")

However when I use the following expression to pull out the corresponding [Quantity] values I am only getting the quantity of the first value.
SUBSTITUTE(SELECT(Works_Orders_Master[Total Quantity],[Charge Number] = [_THISROW].[Charge Number]), " , " , "
")

Any help on this would be great, thank you.

[MultiTech]

What type of column is the Quantity column?

If it’s a number, you’ll need to do something like SUM() - your formula is generating a list of numbers.

If you wish to show the list, change the Quantity to Text (or you could us EnumList).

[MauriceWhelan]

Thank you @MultiTech_Visions, changing the field type to Text worked.

[MultiTech]

If you’re going to want to work with that list of number, it might be easier to use an ENUMLIST column type instead.

Glad it worked!