Set Analysis: How to combine a variable or column with wildcard

[#1]

Hi,

How can I I combine a variable or column with the wild card in set analysis:

Something like this with variable:

sum({$<HID= {$(vHID & '*')}>} Amount)

Or like this syntax with a column:

sum({$<HID= {$(HID & '*')}>} Amount)

Thanks!

[maxgro · Accepted solution]

=sum( {$<HID={"$(HID)*"}>} Amount )

[#3]

And in case I wanna use the variable I just need to replace the field with the variable (vHID) and it should work, right?

=sum( {$<HID={"$(vHID)*"}>} Amount )

[maxgro]

yes I forgot the v