2 Replies Latest reply: Mar 14, 2013 1:39 AM by Nirmal Raj RSS

    DISTINCT values

      Hi all,

       

      I have a scenario where I need to compute for my Days Delayed. Problem is when i sum up my DaysDelayed some are doubled,tripled, and so on. That is because I have records that are distinct but have the same dates to compute days delayed. Are there ways to distinct this without the use of removing the other fields to clasify it as distinct? it's like, I only need to get the 1st record out of n records. If there are 4 distinct records that have the same ID,Dates i need to compute for days delayed, and all other fields are distinct, I need to count that as 1 record so I can use the AVG function.

       

      Thanks,

       

      Donna