Get Months string from NOT selection

[#1]

Hi all,

Please help me with some issue:

I want to get some string that contains the opposite months from my selection in case there is NOT on the selection:

For example: I selected the months Mar, Apr, May, Jun, Jul, Aug, Sep and Dec - I'll see in the Current Selection Box:

"NOT Jan, Feb, Nov"

I want to do some manipulation to get the string: "Mar, Apr, May, Jun, Jul, Aug, Sep, Dec"

Put my example on the attachment...

Thanks!

[ajaykumar1]

Hi,

Take one listbox and in the expression   ='Not' & Monthname

Just try.

Regards,

Ajay

[tresesco · Accepted solution]

In a list box:

='Not Selected Months are : ' &Concat(Distinct {<Month=e(Month)>} Month, ' ,')

[anbu1984]

Concat(Month,',')

[#5]

I did the same but instead e(Month) put p(Month) to get my selected months. Thanks!