3 Replies Latest reply on Sep 19, 2016 8:25 AM by Andrew Watson

    Difference of values between 2 dates

    Ankit Goyal

      Hello everyone,

       

      In my dataset, I'm looking for a difference of values from previous day. For example, below dataset should calculate +9 and 0.19%  (1) difference from previous day (2) % of difference / previous day value. I have attached excel dataset. Have a look, and advise.

       

      Thanks in Advance!

       

      23-Nov-124827
      24-Nov-1248369 (4836-4827)9/4827 = 0.19%