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.