Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sunny,
Maybe you can try this
=CONCAT(DISTINCT {<Id={"=vcity"}>} saleperson,',')
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
How about this one CONCAT(DISTINCT {<Id={"$(=vcity)"}>} saleperson,',')
Not working bro
can you post sample data
Hi Sunny,
Can you attached your app?
Regards,
Sokkorn
Hi
Just move the DISTINCT, its on the wrong place:
=CONCAT({<Id={"=$(vcity)"}>} DISTINCT saleperson,',')
HTH
Jonathan
Thanks Jonathan Its not working
I tried. Thank you all I will upload a sample data soon
Hi.
Variable vcity =concat(DISTINCT {<city={"delhi"}>}Id,',')
Concate({<id = {$(vcity)} >} distinct salesperson, ',')