I cant seem to figure out what i’m doing wrong.
I have a Virtual Column to show information from another table and then concatenate the information. each expression works as a stand alone but i cant get then to work together.
=SELECT(PCH[PC #], [Proposal #]=[_THISROW].[Proposal #]), LIST(CONCATENATE(PCH[PC Vote]," ,",PCH[PC #]))
I want to select the correct information, then concatenate two columns and show the list.
PC Vote E1
Disapprove, PC2 E2
Watch, PC1 E3