2 Replies Latest reply on Jan 24, 2019 10:25 AM by Deepak Rai

    % Daily change

    Megha Bhatnagar

      I have a table with three columns

      step

      date

      count

       

      I want to find the daily % change between the latest and latest-1 date. The latest date will be refreshed everyday. What I am looking to do is find the % change i.e. count for Today/(count for Today-1)-1 for every step

      How can I do that?
      I am attaching a mock workbook.