Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using "=Concat(DISTINCT [ID], ',' )" to fetch the possible values from a list box and store it in a variable but sometimes it returns all the values from the list box. If I just open and close the expression for the variable then it again shows the correct value.
It is not very reliable. Is there any way to fix it?
Thanks,
Jean
If nothing is selected then the Concat() will return all the values. How about:
=If(GetPossibleCount(ID) < Count({1} Distinct ID), Concat(Distinct ID, ', '))