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.
ie:
Proposal#
PC Vote E1
Approve, PC1
Disapprove, PC2 E2
Watch, PC1 E3
E4
Disapprove, PC1
Ideas?
Thank you!
Try this. Create a virtual column in PCH table named [PC all] or something like that with formula CONCATENATE ([PC Vote], “,” ,[PC #], " ")
Now in the other table
CONCATENATE (SELECT (PCH[PC all],[Proposal #]=[_THISROW].[Proposal #]))
Brilliant!
Thank you! I had to add LIST to the beginning
LIST(CONCATENATE (SELECT (PCH[PC all],[Proposal #]=[_THISROW].[Proposal #])))
to get the complete lists but that was the solution i couldn’t see.
Thank you again Sir
Happy to help🙂
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |