6 Replies Latest reply: May 31, 2013 12:16 PM by LEWIS GOLDSTEIN RSS

    Determining if first item in set is selected

      I have a Title Expression that changes based on selection of field EVENT_NUMBER.  If no selections, then title includes 'ALL' in text displayed, otherwise it displays 'TOP' with a selected count.  This is fine as long as the first through n EVENTS are selected.  Below is the expression to accomplish this.

       

      =IF(IsNull(EVENT_NUMBER), ' '

           & If(GetSelectedCount(EVENT_NUMBER) = 0

                    ,'ALL'

                    , 'TOP ' & GetSelectedCount(EVENT_NUMBER)) & ' EVENTS LAST 30 DAYS', ' ' & 'EVENT: ' & EVENT_NUMBER
          
      )

       

      I would like to display 'VARIOUS EVENTS LAST 30 DAYS' if a non-sequential set of Events are selected or if a sequential set not starting from the top.