5 Replies Latest reply on Jan 9, 2018 4:44 PM by Chaitanya Somanchi

    Average number of days calculation

    Chaitanya Somanchi

      Hi All,

       

      I have a view something like the one shown below. The calculation i used for "datediff" is DATEDIFF('day', [Order Date],[Ship Date]).

       

      Please help me in writing a calculated field to determine the average number of days i.e : Sum(Min(datediff))/Countd(Order ID). If you look at the highlighted portion in the picture above it will be 6650/1687.

       

      Attached the sample workbook i created using v10.4

       

      Thanks

      Chaitanya