2 Replies Latest reply on Nov 1, 2013 12:04 PM by christophershanahan0

    Getting Prior Quarter Value to Compute Change

    christophershanahan0


      Hello,

       

      So I've been trying to do something I thought would be easy, but I just cannot get it to work.  I am trying to create a calculation to get he prior quarter value for a variable so I can then compute the difference of and calculate the annualized change.  I know I have to use the Look up function (Lookup(Sum([Credits]),1) and compute using table down along each student.  I've tried every way to Sunday, but am not getting correct results.  Seems to be missing the quarter and is instead pulling the value for the preceding student rather than preceding quarter.  I've seen Joe Mako's clicks example, but I just can't get it to work.

       

      Any help would be appreciated.