Pulling data from the previous repeat

[AnnaSan1]

I have a form I created using an existing hosted layer feature on AGOL. The point layer is of water meter locations with a related table for monthly readings. Currently, my form is set for the field crew to type in the current month's reading, type in the Previous month's reading, and multiple that by a multiplier(a field present in the point layer) to get the value of GallonsUsed for the month. 

However, ideally, I wanted to somehow pull the Previous's month's reading(the value obtained from the previous repeat of that location) into a new repeat to avoid having to look up and type that value in, thus getting rid of the Previous month reading field altogether.

This is what I currently have in my calculation column:

Is what I want possible? Or we stuck with manually entering the values when creating a new repeat?

Thank you

[FaresAl]

Hi Jim, you siad "an enhancement request to introduce indexed repeat functions (e.g., returning the value from the first repeat, last repeat, or a specific repeat x of y)." Do you have any updates on this enhancement request?

[Jim-Moore]

Hi @FaresAl two new functions were introduced in Connect 3.12 (2021) for working with repeat indexes: position(..) and indexed-repeat(). Please refer to the following documentation:

Return the index of a repeat record

Use values from indexed repeats