2 Replies Latest reply on Jul 24, 2012 10:26 AM by Annie Elliott

    Calculated field based on value on a past date?

    Annie Elliott

      For some reason I am stuck!

       

      I have two fields: My_Date and My_Measure.

       

      I need to create a calculated field, My_Target, that, for any given My_Date:

       

      - gets the My_Measure from My_Date 1 year ago (365 days is fine)

      - adds 20.20202020% to that My_Measure from 1 year prior.

       

      Things I think I need to use:

       

      DATEADD('day', -365, My_Date)

      My_Measure  * 1.2020202020

       

      How do I put these two together to get My_Measure on DATEADD('day', -365, My_Date)?

       

      Thanks!