Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Using a text object, I want to list all values for a given field, say field_1, where field_2='x'.
Any ideas?
I thought I could do the following expression would work but no luck:
=if(field_2='x', field_1)
Regards
Revlin
try something like this :
CONCAT(DISTINCT if(field_2='x', field_1) ,' - ',if(field_2='x', field_1)) )
How about:
concat ({<field_2={x}>} field_1, ',')
-Rob
That works great actually. Thanks
Instead of a '-' how can I add a carriage return in between?
Got it I just add the chr(10).
Thanks a bunch guys!