5 Replies Latest reply on Sep 20, 2013 1:22 PM by Robert Prince

    PREVIOUS_VALUE vs LOOKUP([expr],-1)

    Andy Cotgreave

      Hi

      I created a table calc to find the previous value of a running sum. My first attempt was to use PREVIOUS_VALUE, but to no avail. I ended up using LOOKUP(..., -1) which does work. The attached workbook shows the calcs.

       

      Can anyone explain why the PREVIOUS_VALUE calc doesn't work?

      Thanks

      Andy