4 Replies Latest reply on Sep 24, 2018 7:07 AM by Rohail Khan

    Averaging a Value from a calculated field

    Rohail Khan

      Hi All,

       

       

      The ‘Days Since Previous Date’ is itself a calculated field and uses ‘Update Date’ subtracted from ‘Update Date’ – 1 to give the column. Not sure how to calculate the average days spent in each status. (I have also marked the 'Null' values in 'Days Since Previous Date' to show up as 1)


      Any help would be appreciated.