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

[Sokkorn]

Hi Sunny,

Maybe you can try this

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

[#3]

Hi Sikkorn,

Its not working

Also I was trying to add CONCAT(DISTINCT {<Id={"=$(vcity)"}>} saleperson,',')  expression in char (calculated dimensions)  but i dont think it will work like this

[Sokkorn]

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

[#5]

Not working bro

[sreenivas]

can you post sample data

[Sokkorn]

Hi Sunny,

Can you attached your app?

Regards,

Sokkorn

[jonathandienst]

Hi

Just move the DISTINCT, its on the wrong place:

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

HTH

Jonathan

[#9]

Thanks Jonathan  Its not working

I tried. Thank you all I will upload a sample data soon

[senpradip007]

Hi.

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

Concate({<id = {$(vcity)} >} distinct salesperson, ',')