Indexed-Repeat to pull previous pin spacing and resistence measurement

Question

I am using Survey123 desktop app version 3.13.251. For the attached survey form (excel sheet), I am unable to get indexed-repeat to work with this error:

I am using type "note" as mentioned in a previous solution for another similar question and i am following this exact code recommended but I still get this error and would like some help from this well-versed community. I am attaching my code as the excel sheet.

SampleSheet.xlsx

PrabhaVenu · Answer

Thanks for these suggestions, I will give them a try.

dougbrowning · Answer

You may be able to out indexed outside then reference the field inside.

You can also maybe have the calc just outside the repeat so the user can still see it.

But if you just need the values at the 5s I would just have an if that does if mod 5 = 0 then store the number.  Then add all of those up using sum.  This may not be what you need but its an idea.

PrabhaVenu · Answer

Yes, I understand that constraint. Is there a way to get the previous value within this repeat loop? I really need to get this previous value inside this loop, since i am trying to calculate the resistivity for each sample point for a total of > 1 sample points. Basically resistivity at samples points 1, 5, 50 feet, etc respectively. And the formula references the previous sample point (feet and resistivity measured). I would like to do this without asking the person filling the form in the field to have to input the previous values.