5 Replies Latest reply: Nov 29, 2017 4:54 PM by Michael Rainey RSS

    Variables = to other variables

    Michael Rainey

      I'm not sure if I have the syntax right on this:

       

      Let vKey = $(LastName) & ', ' & $(FirstName)

       

      Filter:

      Load

           NameKey,

           Min(Sales)          As minSales

      Resident Master

      Where NameKey = $(vKey)

      Group By NameKey;

       

      This is always returning 0 results when I know there is an exact match in the data.