Show Number and selected value in a listbox

[suren946]

Hi,

Could someone help with below requirement.

I need to show selected value and also how many values are selected in a listbox

Ex: Selected values : In,US,UK and Selected No: 3

[sunny_talwar · Accepted solution]

In a text box object, you can try this

='Selected values: ' & Concat(DISTINCT FieldName, ', ') & ' and Selected No: ' & Count(DISTINCT FieldName)

[shiveshsingh]

Try concat function.

syntax : Concat(DISTINCT Year,',')

[suren946]

Thank You Sunny  your expression helped me

Also below expression gave me the expected output with slight difference in the output

='Selected Value: ' & GetFieldSelections(Field) &' '& 'Selected No:' &GetSelectedCount(Field)