Problems with set analysis sytaxis

[#1]

Hi,

I have this set analysis expresion:

=sum({$<Par={'RTM - SME'}>}MLoc)

and it works correctly.

But I also have a variable called Variable1 which has a string value:

Variable1='RTM - SME'

I am not able to write correctly Variable1 into the set expression.

Even more, I would like to use '*' before and after the string 'RTM - SME' in order to get all the values of 'Par' containing the string 'RTM - SME', I am also unable unable to write this set analysis expression correctly.

Help please.

Thanks

[Sokkorn]

Hi,

Do this

sum({$<Par={$(=Variable1)}>}MLoc)

Regards,

Sokkorn

[Gysbert_Wassenaar · Accepted solution]

The variable can be used like this:

sum({$<Par={'$(Variable1)'}>}MLoc)

With the wildcard * it would look like this:

sum({$<Par={'*$(Variable1)'}>}MLoc)