Get (Record Number) in CALC

[Niet32]

I have a situation where I have a calc:

GetNthRecord (Filed 1; Get (RecordNumber) - 1)

The problen is the Get (RecordNumber) is pulling the record number as the info was imported.

If I create a seperate field that only has Get (Record Number) and I "Do not store calculated results" it puts the correct record number of the found set.

Is there a way to have the Get (RecordNumber) inside the formulas recognize the current records in the found set?

If not how do I can I pull that record number in and have it look up the previous record?

Thanks for any help...

[Niet32]

OK. I got it to work. I swear I just tried the same things several times and it didn't work. Oh well..

I just turned off the indexing in the fornulas field and it worked.