Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Community,
In my text box i have used CONCAT function.
=Concat( if(($(vVariable)>=Date-10) and ($(vVariable)<=Date-5), EmpID), ',')
This expression working fine, but i want to show distinct values in my TextBox...
Thanks in Advance..............
Use DISTINCT then
=Concat(DISTINCT if(($(vVariable)>=Date-10) and ($(vVariable)<=Date-5), EmpID), ',')
Use DISTINCT then
=Concat(DISTINCT if(($(vVariable)>=Date-10) and ($(vVariable)<=Date-5), EmpID), ',')
Actually i have tried DISTINCT, It was throw Expression Error...
i don't know what happend.... now it's working....
Great
Would you mind closing this thread by marking the correct answer.
Best,
Sunny