8 Replies Latest reply: Jul 1, 2014 4:26 AM by Sunil Chauhan RSS

    Exclude nulls in time average calculation

      Hi there,

       

       

      Below is the expression I have where I am averaging the time difference.

       

       

       

      (AVG(Aggr([CE DATE] - [COR DATE],TRACE_NUMBER,TRACE_NUMBER)),' dd hh:mm')

       

       

      I have been requested to not Average any values where [CE DATE]  is null.

       

      Your soonest response will be highly appreciated.

       

      Regards,

      Mpho