6 Replies Latest reply: Oct 29, 2012 6:34 PM by Rob Wright RSS

    Removing - (Hyphen) results with in a Text Object

      Hi, I have the following Expression calculating the result of the top value in a list of activities with values in a Text Object.

       

      In my data there has been a - (Hyphen) transfered with all the results.

       

       

      =FirstSortedValue(Response_Level_2, -aggr(sum({$<Question_List_ID={4},Response_Level_2>}Ans_Minutes),Response_Level_2))

       

       

      How can I exclude the - (Hyphen) results from the results?

       

      Thanks

      Rob