9 Replies Latest reply on Oct 6, 2017 5:12 AM by sudhanshu shukla

    Taking average of two values in differnt column with fixed one value

    sudhanshu shukla

      ON a similar way (Re: Have a quite typical issue regarding building logic in same column ) I want to calculate the average time

       

      Average time =Avg  (Time stamp for ID 201- (Time stamp for ID 301 or Transit time for ID 199)).There can be more than one entry for Code for particular ID and latest updates time to be used for calculation

      The time would be in days :Sample data

       

      IDstatusreasoncodeTime
      bcdaX2P1199x
      bcdaAFNS102y
      bcdaO1NS201z
      bcdaX6NS206a
      bcdaAANS
      bcdaACNS
      bcdaAFNS102mn
      bcdaODNS302tx
      bcdaP1NS202cv
      bcdaP1NS202bh
      bcdaX4FN201nb
      bcdaD1NS301mn
      bcdaCRR4983tx
      jhkgX2P1199cv
      jhkgAFNS102bh
      jhkgO1NS201nb
      jhkgAFNS102mn
      jhkgX6NS206tx
      jhkgAANS102cv
      jhkgACNSbh
      jhkgAFNS102nb
      jhkgODNS302mn
      jhkgP1NS102tx
      jhkgX4FN201cv
      jhkgD1NS301bh
      jhkgCRR4983nb
      ABCDaNS201mn
      ABCDX2P1199tx
      ABCDAFNS102cv
      ABCDX6NS206bh
      ABCDAANS
      ABCDACNS
      ABCDAFNS202tx
      ABCDODNS302cv
      ABCDP1NS302bh
      ABCDABBG
      ABCDP1NS202mn
      ABCDX4FN201tx
      ABCDD1NS301cv
      ABCDCRR4983bh