4 Replies Latest reply on Jul 31, 2015 4:06 PM by laguna92651

    Retrieve Non Repetitive Previous Record

    laguna92651

      Title

      Retrieve Non Repetitive Previous Record

      Post

      I would like to enter the Tot Yr amount from the previous year's December entry into the Previous Yr Tot field of this year's entry. If I use this statement in the Auto-enter Calculation I get the last entry, how can I go back to the previous year's December entry. The number of entries in between the December entries is random.

      Let(N=Get(RecordNumber);If(N>1 ;GetNthRecord (Tot Yr ;N-1)))

      I could filter the view to Decembers only, but would rather not do that.

      Thanks

      Previous_Yr_Field.png