How do I get CONCATENATE to use the Label of ...

[Former Community Member]

How do I get CONCATENATE to use the Label of a Ref column?

I am trying to create a virtual column to use as a row label in a Deck view to show multiple columns of info.

When I use my ID Ref column in CONCATENATE, it shows that actual ID number and not the Label column.

I have tried wrapping it in a TEXT() function thinking that might force the use of the Label.

To clarify, I have a Customers table.

In my CustomerOrders table I Ref the Customer ID have Name as the Label.

When I use CONCATENATE, I get the ID but I want to get Name.