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

    Using a variable in set analysis (for compare)

    Hamish Imrie

      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