If Condition Question

[zwyne]

Hello All,

I am not sure what's I doing here but my statement is

if (Match([Legal Entity],'Close Corporations','Co-Operatives','Foreign Companies','Partnerships','Pension, Provident and Other Funds'),
'Close Corporation','Co-operatives','Foreign Company','Partnership','Pension or provident funds',[Legal Entity]) as CUSTOMER_TYPE_DESC

Please assist.

Regards

[Anil_Babu_Samineni]

Seems, You placed wrong place for Parenthesis.

if (Match([Legal Entity],'Close Corporations','Co-Operatives','Foreign Companies','Partnerships','Pension, Provident and Other Funds'),
'Close Corporation','Co-operatives','Foreign Company','Partnership','Pension or provident funds'),[Legal Entity]) as CUSTOMER_TYPE_DESC

[vvvvvvizard]

if legal entity matches any of those keywords it will return them

[sunny_talwar]

May be you need this

Pick(Match([Legal Entity], 'Close Corporations', 'Co-Operatives', 'Foreign Companies', 'Partnerships', 'Pension, Provident and Other Funds') + 1, [Legal Entity], 'Close Corporation', 'Co-operatives', 'Foreign Company', 'Partnership', 'Pension or provident funds') as CUSTOMER_TYPE_DESC

UPDATED: Updated based on Jonathan's response below

[jonathandienst]

Also comma after the second Legal Entity:

Pick(Match([Legal Entity], 'Close Corporations', 'Co-Operatives', 'Foreign Companies', 'Partnerships', 'Pension, Provident and Other Funds') + 1,

[Legal Entity], 'Close Corporation', 'Co-operatives', 'Foreign Company', 'Partnership', 'Pension or provident funds') as CUSTOMER_TYPE_DESC

[sunny_talwar]

Thanks for pointing that out jontydkpi