Use of record field not in found group for a calculation
I have a calculation field where I'm trying to get a date field from the last record of the total database and then using that field date in a found group of records. My present line of the calculation is:
end = GetNthRecord ( mydatefield ; Get (TotalRecordCount) ) ;
I found that the calculation works great as long as all the records are being displayed. There are 1700 records in the database. However, as soon as I find a group of 400 records, the calculation field doesn't show anything at all.
The database changes weekly and I need a specific date from the last record created in order to do what I want to do when I find a subset of the database.
Any help is greatly appreciated.