AnsweredAssumed Answered

Use of record field not in found group for a calculation

Question asked by ArthurJoyce on Feb 25, 2012
Latest reply on Feb 25, 2012 by ArthurJoyce

Title

Use of record field not in found group for a calculation

Post

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.

Arthur Joyce

Outcomes