1 Reply Latest reply: Mar 19, 2012 4:14 PM by Marc Livingston RSS

    Using a variable in set analysis (for compare)

    Hamish Imrie



      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



      Very strange....