Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Sum({$<$(=$(vChoice('Veges')))>} Spend)
Where vChoice
Pick(Match($1, 'Veges', 'Fruits'),
'[Veges] = {"Cucumber"}',
'[Fruits] = {"Bananas"}')
Try this:
vChoice:
pick(match($1, 'Veges','Fruits')
[Veges] ={"Cucumber"},
[Fruits] = {"Bananas"}
)
=SUM({$ < $(=vChoice('Veges')) >} [Spend])
Try this:
=Sum({$<$(=$(vChoice('Veges')))>} Spend)
Where vChoice
Pick(Match($1, 'Veges', 'Fruits'),
'[Veges] = {"Cucumber"}',
'[Fruits] = {"Bananas"}')
Thank you a lot stalwar1!
Extra $(=...) solves the problem!
@gwassenaarIt doesn't work.