1 Reply Latest reply: Jul 18, 2017 6:52 PM by Mary Jo Taft RSS

    Show matching value in Table

    Justin Dallas

      Hello Folks,

       

      I have a data model with a Table.  In my data model, I have Record Numbers for two different sets of records.  What I would like to do, is show a column whereby if the record number of Instance 1 in RecordSet 1 matches another Instance in RecordSet 2, then that record number is shown.  Here is a screenshot of what I'm trying to do.

       

      Capture23.PNG

       

      As we can see, in the srp_number column, we have matching dra_filenumbers.  I would like to show these on the same row.  My thought process led me to something like this which doesn't work.

       

      IF( (Total dra_filenumber ) = srp_number, dra_filenumber )

       

      I'm trying to say "Ignore selections and data linkage, check over all the srp_numbers, and if they match the dra_filenumber, then put that value in the column".