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)?