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.