2 Replies Latest reply on Jan 28, 2013 12:20 PM by Justin Smith

    Help Displaying the First Value Contained

    Justin Smith

      Hi all,

       

      I have a data set that has a numeric question ID and then corresponding questions. The issue is, the questions also contain the answers and they are mixed. For example:

       

      Question ID                 Question

      12345                         Which is correct, A,B,C,D

      12345                         Which is correct, B,A,C,D

      12345                         Which is correct, B,C,A,D

       

      The questions are the same (except for the order of the answers) and share the same ID.

       

      The issue is, I want to display the question when I mouse over the ID. Since there are multiple values of question for the same ID, it displays and asterisk (*) in the tool tip.

       

      Is there a calculation I can do to display only one of them in the tool tip so it won't try to populate multiple values and give the asterisk?

       

       

      Thanks so much in advance,

      Justin