5 Replies Latest reply: Jun 2, 2016 4:36 AM by Venugopal gummadi RSS

    How to display current selections with separators in a textbox?

    Venugopal gummadi

      Hi,

       

      I want to display the current filter selections in a text box with separators like below:

      Year: 2016; Month: May; Market: USA;

       

      I tried the below code:

      ='Year:'&GetFieldSelections (fiscal_year) &';'&'Month:'&GetFieldSelections (Month)&';'&'Market:'&GetFieldSelections (Market_Name)
      

      which returns the below output when the filters like month are not selected:

           Year: 2016;Month:;Market:USA;

       

      I would like to hide the separator & the label when 'month' is not selected:

           Year: 2016;Market:USA

          

      Regards,

      Venugopal G