Expression not working

[#1]

Hi All,

Can anyone please tell me whats wrong in the below expression?

1 I created a varible

vcity =concat(DISTINCT {<city={"delhi"}>}Id,',')

and its working fine and giving the correct result if i use it in textbox like this  =$(vcity) . It returns result like 1,2,3

now i am trying to use the above varible in the expression below but here its not working. Can some please help me on this?

=CONCAT(DISTINCT {<Id={"=$(vcity)"}>} saleperson,',')

  Thanks a lot

[sudeepkm]

This is surprising that the variable carrying the same info is not working inside the set analysis.

As a workaround you may write your expression like below.

=Concat(DISTINCT {< ID={$(=concat(DISTINCT {<City={'delhi'}>}ID,',')) }   >} salesperson)

[jonathandienst]

Hi

Remove the = sign in the set expression, assuming vcity contains a string:

=CONCAT({<Id={'$(vcity)'}>} DISTINCT saleperson,',')

HTH