4 Replies Latest reply on Mar 15, 2016 11:39 AM by pooja.gandhi

    LOD Calculation: Annual Growth

    Jerry Li

      The following is what I want to achieve:

       

      Annual Growth = Price on last day of year / Price on first day of year - 1

       

      **Note**: First day and last day of year: the earliest or latest day available in the data, doesn't mean fixed 1/1 or 12/31.

       

      Attached a sample workbook.

       

      How to write a LOD cal to return the price for a specific day, for example, give me the price of earliest day on each year.

       

      The quick table calculation "percent difference" doesn't work on this case.

       

      **********************Sample Data**************************************

      Date               Price

      1/1/2010           5

      1/2/2010           7

      12/31/2010      10

      1/2/2011            3

      1/3/2011            5

      12/30/2011        7

      6/7/2012            6

      10/30/2012        8

       

      2010:   10/5-1=1

      2011:   7/3-1=1.33

      2012:   8/6-1=0.33

       

      Joe Oppelt

      Joshua Cloud

      Let me know if you can help.