Using a variable in set analysis (for compare)

[Anonymous]

Hi,

The following expression works perfectly:

=count({<CustomerID={'4'}>}distinct Orders)

However if I insert a variable to replace the 4 as follows I get zero

=count({<CustomerID={'(v_Selected_CounterPart_ID)'}>}distinct Orders)

I have tested the value in the variable and it is 4 so this should work.

The expression editor says the syntax is correct.

The variable is declared as

=GetCurrentField(CounterPart)

Very strange....

Thanks

[#2 · Accepted solution]

Try this:

=count({<CustomerID={"$(v_Selected_CounterPart_ID)"}>}distinct Orders)