Help with SUBSTITUTE() expression


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.

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).

1 Like

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


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!

1 Like