AnsweredAssumed Answered

Retrieve Non Repetitive Previous Record

Question asked by laguna92651 on Jul 31, 2015
Latest reply on Jul 31, 2015 by 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

Outcomes