2 Replies Latest reply on May 3, 2018 10:50 PM by Yadan Wei

    How to get difference between two value with different date?

    Yadan Wei

      When I want to draw a table to show prior price and price change, I don't know how to do it. Here is my original data and target table

       

      Original data

      Effective DateMarket Price
      2017-9-30101.23
      2017-12-31105.56
      2018-3-31108.25

       

      Table needed

      when I filter effective date to  2017-12-31, it will show data below

       

      Prior Price
      Market Price
      Price Change
      101.23105.56(105.56-101.23)/101.23

       

      The same logic applies to 2018-3-31

      Prior PriceMarket Price
      Price Change
      105.56108.25(108.25-105.56)/105.56

       

      I cannot upload a workbook cause company restriction.