Pick(Match()) full string in the Set Analysis

[adamjank]

Hello,

Before I prepare the whole file to show you what is the issue, I write it here:
I've prepare the variable like these:

vChoice:

pick(match($1, 'Veges','Fruits')

'[Veges] ={"Cucumber"}',

'[Fruits] = {"Bananas"}'

)

Then if I put the variable into the Set Analysis according to the official documents, only errors pops up:
=

=SUM({$ < $(vChoice("Veges")) >} [Spend]) it's no working and got this error 'Error: Error in set modifier expression'

Thanks in advance,
Adam

[Gysbert_Wassenaar]

Try this:

vChoice:

pick(match($1, 'Veges','Fruits')

[Veges] ={"Cucumber"},

[Fruits] = {"Bananas"}

)

=SUM({$ < $(=vChoice('Veges')) >} [Spend])

[sunny_talwar · Accepted solution]

Try this:

=Sum({$<$(=$(vChoice('Veges')))>} Spend)

Where vChoice

Pick(Match($1, 'Veges', 'Fruits'),

'[Veges] = {"Cucumber"}',

'[Fruits] = {"Bananas"}')

[adamjank]

Thank you a lot stalwar1!
Extra $(=...) solves the problem!

@gwassenaar‌It doesn't work.