Hi,
I have set a list box up with the following expression in the general tab and changed the field to <expression>.
Then I entered this formula:
=if(len(ID]>0) and len(Location])>0,[Owner]&' - '&[Location])
By joining the statement 'Owner' and 'Issue' in the output of the IF statement the total output in a single column list box is not grouped.
When I set the field to 'Owner' in the general>field tab and use the above expression in the expression tab but set the output to 'Location' only, the 'Owner' field gets grouped and vital information is lost..
It will be easier for the user to use a 2 column list box and ungrouped on Owner and Location.
How can I use the above expression in the expression tab but not group on the field?
Thanks.