I cant seem to figure out what i'm doing wron...

expressions
(Matt Archer) #1

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!

(Syed Faheemuddin) #2

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 #]))

(Matt Archer) #3

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

(Syed Faheemuddin) #4

Happy to help🙂