Variables = to other variables

[mrainey18]

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.

[OmarBenSalem · Accepted solution]

Maybe

Where NameKey = '$(vKey)'

and please, try to debug to see exactly what's happening?

[swuehl]

How are the name variables defined?

Maybe try with single quotes around the names:

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

...

Where NameKey = '$(vKey)'

...

[mrainey18]

This worked thank you.

Where is the documentation that would show this?  I tried looking it up in the community and google but didn't see anything.

[OmarBenSalem]

well logically; when you do a where condition with a string; and if it was sthing static; I mean like:

where yourField='Something'

not

where yourField=Something

You would surround the Something wih quotes since it's a string.

Same approach with your variable.

Where NameKey = '$(vKey)'

not

Where NameKey = $(vKey)

[mrainey18]

Works for me