2 Replies Latest reply on Mar 9, 2016 9:12 AM by Joshua Cloud

    'Sum'ing' on distinct rows

    Hannah Williams

      Hiya

       

      I have a table like the below:

       

         

      Session_idResultsDetails ID's
      12345231
      12346452
      12347253
      12348264
      12349295
      12349296
      12349297

       

       

       

      Total of column results is 206, but in reality it is 148, as results lines show duplicated because of a full join to obtain details ID's. My question is how can I account for this, and get the sum based on the distinct session_id?

       

      Thanks

       

      Hannah